1) Open Excel on your machine by going to: Start > All Programs > Microsoft Office > Microsoft Office Excel 2007

macros-1

2) Click the office symbol on the top left. Then click to Excel Options.

macros-2

3) Click on Trust Center, then Trust Center Settings.

macros-3

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.

macros-4

5) Click OK again.

macros-5