Techniqued- Technoloy, Review and Tutorials
  • Android
  • Freewares
  • Tutorial
  • Windows 11
  • macOS
No Result
View All Result
Techniqued- Technoloy, Review and Tutorials
  • Android
  • Freewares
  • Tutorial
  • Windows 11
  • macOS
No Result
View All Result
Techniqued- Technoloy, Review and Tutorials
No Result
View All Result

How to Enable Macros in Office 2010

Nirmal by Nirmal
March 1, 2011
in Microsoft Office
9
Share on FacebookShare on Twitter

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.

Tags: Enable Macros in Office 2010MacrosMS Office 2010Office 2010Tutorials
ShareTweetSendSend
Previous Post

Manage Mouse Better in Dual Display Set up with DDMM

Next Post

30 High Quality Wallpapers for 2010

Related Posts

Microsoft Office

How to Add an Email Signature in Outlook 2021

November 11, 2022
Microsoft Office

Fix Error ‘This web browser does not support JavaScript or scripts are being blocked’ when adding a Google Workspace Account

November 10, 2022
Microsoft Office

Microsoft PowerPoint Keyboard Shortcuts

October 18, 2022
Microsoft Office

How to Fix Outlook Synchronizing Subscribed Folders Issue

July 27, 2021
Microsoft Office

How to Enable Read Receipts in Outlook [Windows and macOS]

July 17, 2021
Microsoft Office

How to Choose Date Range for Emails to Download on Outlook

July 3, 2021

Comments 9

  1. Tonja says:
    15 years ago

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

    Reply
  2. mar says:
    14 years ago

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

    Reply
  3. Kathleen Powrie says:
    14 years ago

    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

    Reply
  4. Mallikarjun says:
    13 years ago

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

    Reply
  5. JBP says:
    13 years ago

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

    Reply
  6. PLP says:
    12 years ago

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

    Reply
  7. Sendon says:
    12 years ago

    The article is titled How to DISABLE macros. Yet the shot of the dialog window shows a “Disable all macros” option selected. Worse, text then says “make the selections you want,” without explaining what the selections do (it would seem the not-recommended “Disable all macros” option is the relevant radio button, and the checkbox label is gobbledygood to the average user. Oh, and after doing this, with or without checking the checkbox, I still get the “are disabled” popup, macros won’t run..

    Reply
    • Sendon says:
      12 years ago

      Obviously, I meant to type, “The article it titled How to ENable macros.” Is that what Nirmal meant to type? Regardless, the solution still doesn’t work. No solution I have found in two days of searching and trying has worked.

      Reply
  8. PaulZhang says:
    8 years ago

    The solution doesn’t work. excel 2013.

    Reply

Leave a Reply Cancel 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.



Latest Articles

How to Fix “Installation can’t continue” when trying to Update Nvidia Graphics Drivers

Download Windows 11 24H2 ISO (Offline Installer)

Can I Run Windows 11 without Activating

How to Use Snapchat on PC

How to Delete YouTube Search and Watch History on iPhone

How to Use Energy Saver on Windows 11

Techniqued- Technoloy, Review and Tutorials

© 2021 Techniqued - Technology, Tips, Tricks and Reviews

Navigate Site

  • About Us
  • Advertise with us
  • Contact Us
  • Copyright Policy
  • Disclaimer

Follow Us

No Result
View All Result
  • Android
  • Freewares
  • Tutorial
  • Windows 11
  • macOS

© 2021 Techniqued - Technology, Tips, Tricks and Reviews

This website uses cookies. By continuing to use this website you are giving consent to cookies being used. Visit our Privacy and Cookie Policy.