[Solved] Macros Not Working Microsoft Office Excel 2010

by Rohit Khurana on August 14, 2010


Macros have been disabled in Microsoft Office 2010 , this has been done in order to keep your system away from all the vulnerable code that are present in the macros. This macros security feature has been added keeping in mind about the history of the macros viruses, but sometimes we really really need them to get our work done. In this tutorial i will be telling you a very simple way in order to enable your macros when you require them.

The macros are generally used in order to communicate with excel, as VBE uses them to do so. In this tutorial i will not be using any external tool to enable the macros but i will alter some of the default settings in the Microsoft Office which will enable the macros and then you will be able to use it. You will just have to follow the steps mentioned below and then you can enable the macros. The steps narrated below are for the Excel but they are quite similar to the steps to be used in Word.

  1. The excel window will look similar to the one shown below in the snapshot. You see can a green colored tab named as File in the menu bar. Click that tab.
    8-14-2010 2-26-29 PM

  2. You can see the option under File, as shown below in the snapshot. At the bottom of those options you can see two sub-options named as Options and exit, which are written in small font as compared to the others written above it. Click the ‘Option’ tab
    8-14-2010 2-27-07 PM


  3. You will see another window as shown in the snapshot below, where again you can see some of the options enlisted on the left side. Now, on that list click the Trust Center option.
    8-14-2010 2-27-22 PM

  4. You can see the that an option has been highlighted with the green colored circle, which is supposed to be clicked. On clicking that option you will another window which will be similar to the one shown below in snapshot. Now to enable the macros, click the option circled in green in the application window. Though doing this has not been recommended but you can do it and then the macros will be enabled.
    8-14-2010 2-28-37 PM

I hope that this tutorial has met its requirements and it will help you to solve your problem. Please try to use this and leave any comment if you have a better solution to this problem. We will be glad to publish it, if we found it genuine.

If you like this article or this article helped you, you can +1 to recommend this article on google plus.

You can follow us on Twitter or join our Facebook Fan Page. If you have a question to ask us, submit your question at Answers By Trouble Fixers.

Looking for something else? Search here :

{ 16 comments… read them below or add one }

Milind September 7, 2010 at 7:39 pm

Not able to change the level of macro

Vivek September 13, 2010 at 2:35 pm

this is not working for me, it still gives the same error that macros might be disabled for the worksheet…

sample invoice template September 15, 2010 at 6:43 pm

Oh God, you can not imagine how much irritation it has caused for me to enable macros in MS Excel. I was damn stuck up. Thanks ABHINA you have solved such a big problem of mine. The way you have explained is tremendous.

Tbrown December 7, 2010 at 2:25 am

great info thanks for the help the only problem i had was i had to restart excel for this to work for me! Thanks Lee

Madhusoodanan March 20, 2011 at 12:58 pm

Thanks borther, it really did help.

jorge July 2, 2011 at 4:20 pm

it not working for me.. do you have a tricks on this

Vinod February 6, 2012 at 6:05 pm

This helps if the buttons are not greyed out. i have these buttons greyed out. not sure sure how to ungrey them to enable these macros later

santosh February 29, 2012 at 1:47 am

How do i record a macro in excel 2010?

alan wilhite April 10, 2012 at 2:35 am

This helps if the buttons are not greyed out. i have these buttons greyed out. not sure sure how to ungrey them to enable these macros later

Marco May 28, 2012 at 3:37 pm

This is a great way of enabling all my macros on my Excel but is there a way setting up a workbook to automatically enable macros upon opening? Not only on my pc but on whoever opens the document? I have a file which various people need to complete but macros need to be enable in order for them to be prompted to complete the document.
Your help would be greatly appreciated.

Robert June 1, 2012 at 1:50 am

To fix this problem, all you have to do is copy your info into a new document and you will no longer get the error message

nitin July 30, 2012 at 12:42 pm

really helpful …!!! thanks Abhinav

Dilip August 16, 2012 at 1:51 pm

Hi, Even after doing all the process as mentioned the macro is still not enabled. I have even restarted the computer twice. Is there any other issue.

Kishore October 10, 2012 at 4:42 pm

This helps if the buttons are not greyed out. i have these buttons greyed out. not sure sure how to ungrey them to enable these macros later

vijay khurana January 20, 2013 at 2:01 am

i changed all the setting as above but the macros do not work pl help???

jmatoushek February 22, 2013 at 9:29 pm

I changed all the setting to enable all macros but when another individual gets into my workbook the macros don’t work. Does anyone know whats going on or can anyone help?

Leave a Comment

Previous post:

Next post:

© TroubleFixers – All about fixing computer troubles2007-2017 . All Rights Reserved.