Click on Microsoft Office, then click on Excel Options.
Click on Trust Center.
Click on Trust Center Settings.
Click on Macro Settings.
Select the Configure access to the VBA project object model check box.