[Solved]: Macro Settings Greyed out in Excel

Get FREE Advanced Excel Exercises with Solutions!

It is risky to activate macros because problems could arise when viewing a spreadsheet that has macros enabled. Due to security concerns, Excel disables macros from outside sources. This article explains how to activate Excel macro settings greyed out effectively with appropriate illustrations and the risks involved.


If Macro Settings Is Greyed out in Excel (With Easy Solutions)

Let us have a data set like this. We have a record of the income statements of several people. We will enable macro settings greyed out using this dataset. Here’s an overview of the dataset for today’s task.

excel macro settings greyed out


Step 1: Create Dataset with Proper Parameters

In this step, we will create a dataset with the proper parameters. We will enter the heading of our dataset like in the below screenshot. Hence, format it as we want from the Home tab.


Step 2: Enable Macros

In this step, we will learn how to enable macros in Excel. To do that, simply have a look at the below GIF file.

  • We will select the Options command under the File tab.
  • As a result, an Excel Options dialog box pops up. From the Excel Options dialog box, select Trust Center Setting from the Trust Center option.
  • Hence, select Enable VBA macros (not recommended, potentially dangerous code can run) from the Macro Settings option.

Enable Macros


Step 3: Open Run Dialog Box

Sometimes you can’t use a function of a program because you’re “greyed out.” Your grey enable/disable button is inactive when you click it; nothing occurs. The Excel application is also susceptible to this. However, you can still use the following instructions to enable the macro setting greyed out:

  • Press the  Windows key + R key  Hence, a Run dialog box will appear in front of you. From the Run dialog box, type GPEDIT.MSC in the Open typing box. At last, press the OK option.

excel macro settings greyed out

  • After that, a Local Group Policy Editor dialog box pops up. From the Local Group Policy Editor dialog box, select Administrative Templates from User Configuration.
  • Further, go back to your Excel workbook.


Step 4: Go to Trust Center Option

  • Now, select the Options command under the File tab.

  • As a result, an Excel Options dialog box pops up. From the Excel Options dialog box, select Trust Center Setting from the Trust Center option.

excel macro settings greyed out


Step 5: Use Trusted Locations Option

  • After that, do like the below screenshot.

  • After pressing the OK button, you will go back to the Excel Options dialog box. Again, press OK.
  • Finally, you will be able to enable macro settings greyed out.

excel macro settings greyed out


Step 6: Restart Your PC

  • After completing the above process, simply restart your PC to activate the macro settings greyed out.

Notes: Enable to Disable Macros in Excel

To do that, check the Disable VBA macros with a notification from the Macro Settings option under the File tab.

excel macro settings greyed out


Bottom Line

👉 You can pop up the Microsoft Visual Basic for Applications window by pressing  Alt + F11  simultaneously.

👉 If a Developer tab is not visible in your ribbon, you can make it visible. To do that, go to,

File → Option → Customize Ribbon


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Conclusion

I hope all the suitable methods mentioned above to enable macro settings greyed out will provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.


Related Articles

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Abdur Rahim Rasel
Md. Abdur Rahim Rasel

MD. ABDUR RAHIM is a marine engineer proficient in Excel and passionate about programming with VBA. He views programming as an efficient means to save time while managing data, handling files, and engaging with the internet. His interests extend to Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning, reflecting his versatile skill set. He earned a B.Sc in Naval Architecture & Marine Engineering from BUET, and now he has become a content developer, creating technical content... Read Full Bio

2 Comments
  1. Hi,

    What do you do under User Configuration/Administrative Templates?

    • Hi WOLFIXX,
      Greetings. Thanks for commenting. You just need to select Administrative Templates from User Configuration from the Local Group Policy Editor dialog box.

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo