How to Enable Macros in Excel?


In Excel, macros are disabled by default for enhanced security. Below are the steps to
Enable Macros in two different versions of Excel:
1 Excel 2007 Version
2 Excel 2010 Version


Enabling Macros in Excel 2007:
1 The picture below shows a Security Warning in a worksheet in which macros are disabled.


2 Click Options button


3 Check Enable this Content and Click Ok in the Security Alert-Macro box.


Enabling Macros in Excel 2010:
1 The picture below shows a Security Warning in a worksheet in which macros are disabled.


2 Click Enable Editing button.
Just by clicking the Enable Editing button, Excel is ready to enable all the macros.
How to enable macros in excel.pdf