Macros are disabled by default in Office 2010(Word 2010, Excel 2010, PowerPoint 2010, etc) for enhanced security. Enabling Macros is easy but Microsoft Office team has hidden it deeper inside Options.
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.
It’s 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.