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.
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.
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
- Then, go to the Info
- After that, select Enable Content.
- Excel will enable the Macros.
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.
- 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.
Read More: [Fixed!] Formulas Are Not Calculating Automatically in Excel
Similar Readings
- [Fixed!] Excel Filter Stops at Blank Row (4 Possible Solutions)
- [Fixed!] Unshare Workbook Greyed Out in Excel
- [Fixed!] Excel Scrolling Too Many Rows (2 Easy Solutions)
- [Fixed!] Auto Fill Options Not Showing in Excel
- [Fixed] Excel COUNT Function Not Working
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.
- 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.
- Now, open the file from the trusted source.
- After opening the file, you will see no warning message.
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
- 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. Please visit Exceldemy for more useful articles like this.
Related Articles
- [Fixed!] Excel Iterative Calculation Not Working
- [Solved]: COUNTBLANK Not Working in Excel
- [Solved] Excel Formatting Not Working Unless Double Click Cell
- [Fixed!] Excel Hyperlink Keeps Coming Back (5 Quick Solutions)
- [Solved:] Excel Not Filtering Entire Column (3 Quick Fixes)
- [Fixed!] Excel COUNTIF Function Not Working for String “True”