Setting Macro Security- Office 2010/2016/2019
At the top, click on “File.” |
|
Then click on “Options.” |
|
Look for and then click on “Trust Center.” |
|
|
A box that says Microsoft Trust Center will pop up. In the lower right-hand corner of that box, you will need to click on “Trust Center Settings.” |
|
You will then select “Trusted Locations.” |
|
You will see “Add new location”…click on that near the bottom. |
|
This box will pop up. |
Browse out to c:APGReporting |
Type the pathname of where the spreadsheets are, the default is c:APGReporting |
|
|
Then you’ll click “OK” and then click “OK” a gain.
|
|
Close and reopen the spreadsheet. |
|
The error with the security warning will be gone. |
|
Updated