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

Get FREE Advanced Excel Exercises with 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.

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: Activating 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: [Fixed] Excel Macros Enabled But Not Working


Solution 2: Enabling Macros from the 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


Solution 3: Enabling Macros from the 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.


Solution 4: Opening 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 that 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: Using 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 window.
  • Then, go to the View tab.
  • 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.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , and premium Excel consultancy services for Excel and business users. Feel free to contact us with your Excel projects.
Akib Bin Rashid
Akib Bin Rashid

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo