[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.

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.

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.

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

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

Excel will enable the Macros.

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.

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.

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.

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.

Now, open the file from the trusted source.

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

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

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

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.