Blocked Macros? Enable Macros in Microsoft Excel & Microsoft Office
Some people say, “The World runs on Macros”. This is true, almost every small office to large enterprise companies across the world use macros for Office Automation.
While opening a macro enabled file that you have saved on your computer, you may see one of the following messages.
1. Macros have been blocked
Option A - Add Trusted Location
If you trust the file then simply create a folder on your computer and tell Excel that it is a trusted folder. That’s it! All files opened from a trusted folder will open up without any warning messages.
Note: Gantt Excel’s code is secure and digitally signed by Comodo.
You can watch this step by step video for “How to Enable Macros when Macros are blocked“
Option B - Unblock File
Another easy option is to just right click on the filename in Explorer, Select Properties and click the Unblock checkbox. You will have to do this only once and the file will stay unblocked.
You can watch this step by step video for “How to Enable Macros when Macros are blocked – Unblock File“
2. Enable Macros/ Content Prompt
This is an easy one. Just click on the Enable Content button and macros will be enabled.