Macros are disabled by default in Office 2010(Word 2010, Excel 2010, PowerPoint 2010, etc) for enhanced security. However it might happen that you need to enable macros because some installed Application needs to use the Macros without confirmation (this is especially for applications running inside well firewalled DMZ-ed networks).

Enabling Macros is easy but Microsoft Office team has hidden it deeper inside Options. Here is how to Enable All macros in Excel 2010

First click the File Menu(Office Backstage) and select Options from the left sidebar. In options, select Trust Center from the left sidebar and click Trust Center Settings button on the main window.

Now in Trust Center Settings dialog window, select Macro Settings from the left sidebar, choose Enable All Macros option and hit OK.

Its that simple. From now onwards Excel 2010 won’t bother you anymore about Macro security. It is recommended that you use this option only when you are installing trusted add-ins and opening trusted documents. If an unknown dangerous macro code runs, then it could corrupt your Office 2010 installation or give you other sorts of problems.

You can use the above procedure to enable macros in Word 2010, PowerPoint 2010, Outlook 2010, etc