Enable/Disable Macro In Excel

Let’s see how we   can Enable or Disable macros in an excel workbook.

Step 1

Click on File at the top left corner in the excel workbook and click on Options at the last.

Capture




Capture

Step 2

Click on Trust Centre Settings under Trust Centre Options at the bottom right.

Capture

Step 3

You will see  the below macro settings window where you could select the options as per your requirement to enable or disable the macros, press ok and save and close the file.

Your change in settings will be reflected now.




Capture

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply