[Solved]: Macro Settings Greyed out in Excel

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.


Download Practice Workbook

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


Step-by-Step Procedures to Solve If Macro Settings Is Greyed out in Excel

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.

Read More: Excel Data Validation Greyed Out (4 Reasons with Solutions)


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

Read More: [Solved!]: Excel Page Layout Being Greyed Out (4 Quick Fixes)


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.

Read More: [Fixed!] IF Function Is Not Working in Excel (4 Quick Solutions)


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

Read More: [Fixed!] Merge Cells Button Is Greyed Out in Excel


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

Read More: [Fixed!] Auto Fill Options Not Showing in Excel


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

Read More: [Fixed!] Unshare Workbook Greyed Out in Excel


Bottom Line

👉 You can pop up 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


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 can also visit our website, ExcelDemy to learn more Excel-related content. You are most welcome to feel free to comment if you have any questions or queries.


Related Articles

Tags:

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo