1. Home
  2. MS Office

How To Enable All Macros In Excel 2010 (For Advance Users)

By Default, All Macros option is disabled in Excel 2010 due to the fact that any kind of malicious code can run which can seriously harm your work. However, if you’re an advanced user and want to enable all the macros, you can do it from Excel 2010 Trust Center Settings.

To enable all macros, on File menu, click Options.


It will bring up Excel Options, from left sidebar, click Trust Center and from main window, click Trust Center Settings.


This will lead you to Trust Center dialog, from left sidebar, select macro Settings and from main window, click checkbox of Enable all macros option and hit OK to enable all the macros.


1 Comment

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.