[Solved] Macros Not Working Microsoft Office Excel 2010

[Solved] Macros Not Working Microsoft Office Excel 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.
   

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
   

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.
   

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.
   

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.