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

security risk blocked macros

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.

39 thoughts on “Blocked Macros? Enable Macros in Microsoft Excel & Microsoft Office”

  1. Hello, Unblocking did not work for me.

    I use WPS not microsoft excel. It says the Macro can not be run because the VBA support library is not installed.

    Please can you help me?

    Reply
  2. Hi im trying to enable macros on a Gantt chart on a Mac and when I do it keeps asking me for a password which I never set up in the first place. Can you please assist?

    Reply
  3. The option to unlock the file does not show up, but I get a brief message in red, saying the automated macro is off. Please help.

    Reply
  4. Once the chart us downloaded, will it pass the data to your server or not? Using your freely available GANNT chart will breach any of organization security policy or data breach?

    Reply
  5. This is great, but I’m a bit concerned. Once I download this to my device, does that mean my entire team will also need to have it on their devices to be able to edit and view the chart?

    Reply
  6. Can I use Free Template forever for my work?
    Could you please let me know if I need to pay any fee in for free template, I hope my data will not impact.

    Reply
    • Naveen, Sure you can. The data stays in your excel file on your system. We have no access to your data and that’s why everyone in the world love Gantt Excel as their project data is safe and not on the cloud.

      Reply

Leave a Comment