Enabling all the Macros in Microsoft Excel 2010


The Macros feature by default has been disabled or to put in a better way, it is hidden in all the Microsoft Office programs like the Excel, word, PowerPoint and Outlook for the reason of grater security. But, however you can enable all the Macros but it is not recommended as some dangerous Macros if executed would affect the whole MS Office suite and degrade your System’s performance. Here is a tutorial that will allow you to enable all Macros in the Excel 2010 Application.

1) Click on the ‘File’ tab and then on ‘Options’ tab.

Figure 1

2) In “Outlook Options” window, select the ‘Trust Center’ tab and then click on the ‘Trust Center Settings’ tab.

Figure 2

3) Now in the “Trust Center Settings” window, click on the ‘Macro Settings’ tab and then under the ‘Macro Settings’ group, select the check box that says “Enable all Macros”.

Figure 3

So, this is all to the enabling of the Macros feature in Excel 2010 but it is not a recommended tip.

See also How to Assign a Macro to an Option Button in Excel 2010

Read Other Applications