Setting Macro Security- Office 2010/2016/2019
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. |
|
Related Articles
Setting Macro Security - MS Office 2007
Office 2007- Setting Macro Security Excel 2007 works differently than previous versions of Excel. In order to allow the buttons and macros to work correctly in your CCI spreadsheets, you will need to complete the procedure listed below on each PC ...
Setting Macro Security - Excel 2016
Setting Macro Security - Excel 2016 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 ...
Avoiding the "security warning" when opening spreadsheets (enable content)
When a spreadsheet is opened, if the message below is displayed, macro security has not been set. There is another article in our solutions database about how to set this depending on the version of Office. (Issue: You cannot click on the Red ...
Adding the Conditional Formatting in Office 2007/2010
Adding the Conditional Formatting in Office 2007/2010 From the Home tab, click on Conditional Formatting, New Rule Select “Use a formula to determine which cells to format” And then type the formula =COUNTIF($C:$C,E23)=0 (where Column C is the column ...
Charting Board Report Information with Office 2007
Charting Board Report Information with Office 2007 Click Attachments to view the document