1) Open Excel on your machine by going to: Start > All Programs > Microsoft Office > Microsoft Office Excel 2007
2) Click the office symbol on the top left. Then click to Excel Options.
3) Click on Trust Center, then Trust Center Settings.
4) Click on Macro Settings and the radio button to “Enable all macros” and “Trust access to the VBA project object model” and then click OK.
5) Click OK again.