How to unblock macros from access

To unblock macros in Microsoft Access, you can follow these steps:

1. Open the File Properties: Right-click on the Access file you want to unblock and select Properties.
2. Unblock the File: In the General tab of the Properties dialog, look for the Unblock checkbox. If it is present, check it and then click OK.
3. Use Group Policy: If you are managing multiple users or devices, consider using Group Policy to manage how Access handles macros. You can find the relevant policy under User Configuration > Policies > Administrative Templates > Microsoft Access 2016 > Application Settings > Security > Trust Center.
4. Enable Content: When you open a file with macros, you may see a Trust Bar warning. You can click Enable Content to allow the macros to run for that session.

If the Unblock checkbox is not available, you may need to designate the file location as a Trusted site or add it to the Local intranet zone to ensure macros are not blocked.

References:

• Steps to take to allow VBA macros to run in files that you trust
• Use policies to manage how Office handles macros

Hi @Jalee Adams,

Thank you for posting your question to the Microsoft Q&A forum.

According to your concern, to unblock macros from access, please follow the below steps:

1. Move the database to a trusted location:

• Go to File > Options > Trust Center > Trust Center Settings.
• 

Identify a trusted location where you can move the database.

• Check "Allow Trusted Locations on my network".

2. Check the file property of your Access file

• Find the Access file in Windows Explorer. Right-click the file and select Properties.
• At the bottom of the "General" tab, you should see a "Security" option.
• Check the "Unblock" checkbox, then click Apply or OK.

I hope this information is helpful. Please follow these steps and let me know if it works for you. If not, we can work together to resolve this.    

Thank you for your patience and your understanding. If you have any questions or need further assistance, please feel free to share them in the comments on this post so I can continue to support you. 

I look forward to continuing the conversation.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

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.