[Fixed!]: Unable to Enable Macros in Excel (5 Quick Solutions)

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. Visual Basic Application (VBA) is a very useful tool in Excel. However, sometimes, we find problems in enabling macros in Excel. In this article, I will explain 5 solutions for unable to enable Macros in Excel.


5 Suitable Solutions When You Are Unable to Enable Macros in Excel

This is an Excel sheet that has VBA macros in it. You will notice that there is a warning sign that the Macro is disabled.

unable to enable macros in excel

I will explain how to enable it.


Solution 1: Activate Enable Macros Option

  • The simplest way to enable the Macros is to select the Enable Content

  • Excel will enable the Macros.

Enable Macros from File Tab

Read More: [Solved]: Macro Settings Greyed out in Excel


Solution 2: Enable Macros from File Tab

The next solution is to enable Macros from the File tab. Let’s do it step by step.

Steps:

  • First of all, go to the File

enable macro button in excel

  • Then, go to the Info
  • After that, select Enable Content.

  • Excel will enable the Macros.

Enable Macros from File Tab

Read More: [Fixed!] Macros Not Working in Excel (3 Possible Solutions)


Solution 3: Enable Macros from Trust Center

The next solution is the use of the Trust Center.

Steps:

  • First of all, go to the File

  • Then, go to the Options.

Trust Center unable to enable macros in excel

  • The Excel Options window will open.
  • Then, select Trust Center.
  • After that, go to Trust Center Settings.

  • Then, from the Trust Center Settings, go to the Macros Settings.
  • After that, select the Enable VBA Macros
  • Then, click OK.

unable to enable macros in excel

  • Excel will enable the macros.

Read More: [Fixed!] Formulas Are Not Calculating Automatically in Excel


Similar Readings


Solution 4: Open Excel Files from Trusted Locations

This time, I will show another solution using the Trusted Location.

Steps:

  • Go to the Trusted Location from the Trust Center Settings.
  • Then, select Add New Location.

Trusted Location enable macros in excel

  • A new box will appear. Select Browse from the box.

  • Then, select the location which Excel will consider a trusted one.
  • After that, click OK.

Trusted Location enable macros in excel

  • Now, open the file from the trusted source.

  • After opening the file, you will see no warning message.

Trusted Location enable macros in excel


Solution 5: Use VBA xlSheetVeryHidden Property

Next, I will show how you can use the xlSheetVeryHidden property to enable macros.

Steps:

  • Press ALT+F11 to bring the VBA
  • Then, go to the View
  • After that, select Properties Windows.

  • After that, from the visible field, select the xlSheetVeryHidden

VBA to enable macros

  • Now, on returning to the Excel file, you will find no warning sign.

unable to enable macros in excel


Things to Remember

  • Enabling VBA Macro in the 3rd method is not recommended by Excel.

Conclusion

In this article, I have explained 5 solutions for the problem of for unable to enable Macros in Excel. I hope it helps everyone. If you have any suggestions, ideas, or feedback, please feel free to comment below. Please visit Exceldemy for more useful articles like this.


Related Articles

Tags:

Akib

Akib

Hi, this is MD Akib Bin Rashid. I completed my BSc in Engineering back in 2019. After that, I did an MBA. Then, I joined as an Excel and VBA Content Developer at SOFTEKO Digital. Being passionate about data analytics and finance, I will try to assist you with Excel

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo