unlock macros in excel

Question

How do I unlock macros in excel in a file sent from a trusted source?

Answer 1

To unlock macros in an Excel file sent from a trusted source, you can follow these steps:

1. Open the File: Open the Excel file that contains the macros.
2. Check for the Unblock Option: Right-click on the file in Windows Explorer, select Properties, and look for an Unblock checkbox on the General tab. If it is present, check it and click OK.
3. Enable Macros: If the file is opened and you see a security warning about macros being disabled, you can click on Enable Content in the yellow warning bar at the top of the Excel window.
4. Trusted Locations: If you frequently use files from a specific location, consider adding that location as a Trusted Site in your Excel settings to avoid having to unblock macros each time.

By following these steps, you should be able to unlock and enable macros in Excel for files from trusted sources.

---

References:

• How Office determines whether to run macros in files from the internet
• Steps to take to allow VBA macros to run in files that you trust

Answer 2

Hello, thank you for reaching out to Microsoft Q&A.

To unblock macros, add the file or folder to the trusted location settings.

1. Open Microsoft Excel.
2. Select the File and click Options.
3. Select Trust Center.
4. Click Trust Center Settings and Select Trusted Locations.
5. Select Add a new location.
6. Add the folder path (location) where your file is stored. This tells Excel to trust all files inside that folder.
7. Make sure you check "Subfolders of this location are also trusted."
8. Click OK to save.

Restart the Office apps (Microsoft Excel) and run the Macros.