Share via

how to enable macros in a ms access file

Jorge Abate 20 Reputation points
2025-12-26T14:01:41.7766667+00:00

I wonder how to enable macros in a ms access file. This error message is displayed when opening the MS Access file: Microsoft has blocked macros from running because the source of this file is untrusted

Microsoft 365 and Office | Access | For home | Other
0 comments

Answer accepted by question author

AI answer

2025-12-26T14:01:48.43+00:00

To enable macros in a Microsoft Access file that is blocked due to being from an untrusted source, you can follow these steps:

  1. Unblock the File: Right-click on the Access file, select Properties, and in the General tab, check the Unblock checkbox if it is available. This will remove the Mark of the Web from the file.
  2. Trust the Location: If the file is stored on a network share or a trusted website, you can designate that location as a Trusted site. This can be done through the Trust Center settings in Access.
  3. Open in Desktop App: If the file is stored on OneDrive or SharePoint, ensure users open the file using the Open in Desktop App option. This can help bypass the macro restrictions.
  4. Enable Content: If you see a security warning when opening the file, you can select Enable Content on the Trust Bar if it appears. This will allow macros to run for that session.

By following these steps, you should be able to enable macros in your Access file and run them safely.

References:

AI-generated content may be incorrect. Read our transparency notes for more information.

Was this answer helpful?

1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Gabriel-N 17,785 Reputation points Microsoft External Staff Moderator
    2025-12-26T14:51:20.89+00:00

    Dear Jorge Abate

    Thank you for reaching out to the Q&A forum.

    If your error message matches the screenshot shown below, please follow the first suggestion in the Q&A Assist response: right‑click the Access file, choose Properties, and under the General tab, check the box labeled Unblock. This should allow the file to open normally.

    User's image

    I’ve added the picture to clarify how you can apply this option.

    User's image

    If the first method doesn’t unblock your file, please try these steps:

    1> Add the folder where you downloaded the file as a Trusted Location:

    • Go to File > Options > Trust Center > Trust Center Settings > Trusted Locations.
    • Make sure to tick “Subfolders of this location are also trusted.”

    User's image

    User's image

    2> Temporarily Enable Macros in Trust Center Settings.

    User's image

    Hope this information is helpful!

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.  

    Was this answer helpful?

    2 people found this answer helpful.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.