Home / Microsoft Office / How to Enable Macros in Office 2010

How to Enable Macros in Office 2010

Macros automate frequently-used tasks in Office 2010 and they are created with Microsoft Visual Basic for Applications (VBA) and are written by software developers. But Macros also pose potential security risk and because of this macros are disabled by default. But you can enable them from the application you are using and want to use macros. Macro security settings are located in the Trust Center and you can enable using the steps below.

microsoft-office-2010-logo1

1. Click the File tab and click Options.

File Options

2. This will open the Options dialog box, click Trust Center, then click Trust Center Settings.

Trust center settings

3. In the Trust Center, click Macro Settings.

Enable Macros

Make the selections you want. Click OK.

Based on the selection you chose, Macros will be enabled. One important thing to note here is that macros will be enabled only for the application you enable it and not for Office 2010 as a whole. For example if you enable macros in Word 2010, then it wont be enabled for all other Office 2010 application, it needs to be enable for each application.

About Nirmal

Nirmal is a Technology Blogger and a Microsoft MVP in Windows. He can be contacted at nirmal@nirmaltv.com. You can find Nirmal on , and .
  • Tonja

    I have tried every method I could find on the web, but I still cannot enable macros for MS 2010. Can someone please help!

  • mar

    for those who have the same problem- u need to reopen word doc after applying change as it is above :)

  • Kathleen Powrie

    I cannot enable macros in MS2010. I too have done everything that I can find in help and on the web and nothing works.
    Yes I have re opened the word doc….any other ideas please

  • Mallikarjun

    The above steps work but when we want to enable the macros in the file it does’t work. Any clue

  • Pingback: Command Button Word 2010

  • JBP

    Bu how about is the option buttons are disabled? I my case I can’t select any!!!!

  • PLP

    In my case as well I am not able to select any , all radio buttons are diabled.

Scroll To Top