Enable All Macros In Excel 2010

By Nakodari on Dec 22 2009 9 Comments

Macros are disabled by default in Office 2010(Word 2010, Excel 2010, PowerPoint 2010, etc) for enhanced security. Enabling Macros is easy but Microsoft Office team has hidden it deeper inside Options.

First click the File Menu(Office Backstage) and select Options from the left sidebar. In options, select Trust Center from the left sidebar and click Trust Center Settings button on the main window.

Excel Trust Center Settings

Now in Trust Center Settings dialog window, select Macro Settings from the left sidebar, choose Enable All Macros option and hit OK.

Office 2010 Trust Center

It’s that simple. From now onwards Excel 2010 won’t bother you anymore about Macro security. It is recommended that you use this option only when you are installing trusted add-ins and opening trusted documents. If an unknown dangerous macro code runs, then it could corrupt your Office 2010 installation or give you other sorts of problems.

You can use the above procedure to enable macros in Word 2010, PowerPoint 2010, Outlook 2010, etc.

  • Pingback: Compare Two Excel 2010 Worksheets | 48da Tech News

  • royuk

    Allowing all macros to run automatically is a potentially dangerous move. The user needs to be sure of the source of the code or else potentially malicious macros could run. Never use this option but create a Trusted Folder (see http://technet.microsoft.com/en-us/library/cc17…) and only put workbooks that you are sure are safe in it. These workbooks will then open without the alert.

  • CJ GROSS

    Microsoft is awesome with their online training. We just upgraded and haven’t taken the time for classes. You are available to get us through our daily tasks.
    Thanks so much!!!!!!!!!!!!!!!!!!!!!!!! :-)

  • Mahesh

    sir,
    I make a enable macro sheet of username & password but my client when open this sheet open with out username & password not run macro because its macro seeting is a disable so i have no change its pc in macro securities other i change its securities so he know this suspense and he change enable macro to disable macro and open my worksheet without password so i not opened this sheet without username & password and no change seeting in macro securities please help me

  • Bryan

    Ugh. So they decided that querying the user was too scary or something? Very annoying that the code that I’ve just written in the program won’t run. Kind of insane, more than annoying.

  • bahrul

    thank’s

  • Pingback: How to make an Outlook macro that moves ALL messages in a conversation? | Coding Answers

  • Idan

    Thank you.

  • BN

    This did not work for me. When I went back in Word my macros were missing.

    • kirsten

      BN, you need to close the program and reopen after enabling.

  • Olivia

    When I go to Trust Center Settings, all of the options on your screen do not show up on mine. Macro Settings is not an option on the left hand side. Any suggestions?

    Thanks for your help.