Get Security warning Macros have been disabled in Microsoft Office 2010
If Macros have been disabled in your Office, this is to get rid of the vulnerable code the Macros has. The Macros security has been added to remind the user of the Macro viruses. But most of the time, we need to enable it to finish our work. We used Macro to communicate with Excel. You can set to enable all Macros in the Trust Center Settings. When you are using Excel, just click the File menu.
Click the Option tab at the bottom of the File option.
A new window will appear, select the Trust Center tab on the left pane and then click Trust Center Settings under the Microsoft Excel Trust Center and click OK.
Under the Macro Settings tab, tick the Enable all macros and click OK. You have just set to enable all Macros.