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:

Excel 2007 version

Excel 2010 version

Enabling Macros in Excel 2007:

The picture below shows a Security Warning in a worksheet in which macros are disabled.

Enabling macros


Click Options button.

Enabling macros

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

Now the macros are enabled.

Enabling Macros in Excel 2010:

The

picture below shows a Security Warning in a worksheet in which macros are disabled.

enable macros 2007

Click Enable Editing button.

Just by clicking the Enable Editing button, Excel is ready to enable all the macros.

—————————————————————————————————————————————————-

Vani is a Business Associate with p2w2, a Spreadsheet Solutions company. p2w2 has expertise in Excel Modeling, Excel Dashboards, Profitability Analysis,  Excel Invoices and Excel Bid sheets. You can contact us by email: cs [at] p2w2.com or call us at 305.600.0950.

2 Replies to “How to Enable Macros in Excel?”

Leave a Reply

Your email address will not be published. Required fields are marked *