1.   Open Microsoft Excel.

2.   Click on Office button if top left corner.

3.   In it, click on Excel Options below.

4.   Once in Excel Options, select “Trust Center” & click on “Trust Center Settings..” as shown below.

5.   In Trust Center, click on “Macro Settings” and enable/select “Trust access to the VBA project object model”

6.   Click on OK twice.

7.   You will have to exit and restart Excel for the settings above to be effective.

1.   Open Microsoft Excel.

2.   Go to Tools->Macro->Security

3.   In the Security window, go to Trusted Publishers & enable/select “Trust Access to Visual Basic Project”.

4.   Click on OK.

5.   You will have to exit and restart Excel for the settings above to be effective.