Click the 'Trust Center Settings.' From the Trusted Center window, choose the Trusted Locations from the left navigation. From here, you can add a new location, remove, or modify existing entries using the respective buttons. If you are using 64bit Office on 64bit OS, the location should be. HKEYLOCALMACHINE SOFTWARE Microsoft Office 16.0 Access Security Trusted Locations The registry keys work for me when I test with Office 2013 15.0.4953.1001 and Office 2016 Version 1705 Build 8201.2193. It would add trusted locations as Policy Locations.
![](/uploads/1/2/7/7/127720295/316475764.jpg)
Related articles:
Load more
![Add Trusted Location For Powerpoint On Mac Add Trusted Location For Powerpoint On Mac](http://applewebonline.com/computer_fix_repair_Mac_PC_laptop/wp-content/uploads/2016/11/computer_problem_vancouver-300x276.jpg)
If the thought of any Excel macro message coming up (even one time) unnerves you, set up a trusted location for your files. A trusted location is a directory that is deemed a safe zone where only trusted workbooks are placed. A trusted location allows you and your clients to run a macro-enabled workbook with no security restrictions as long as the workbook is in that location.
To set up a trusted location, follow these steps:
-
On the Developer tab, select the Macro Security button.This activates the Trust Center dialog box.
-
On the left, click Trusted Locations.The Trusted Locations menu appears, displaying all the directories that are considered trusted.
-
Click the Add New Location button.
-
Click Browse, and find and select the directory that will be considered a trusted location.
After you specify a trusted location, any Excel file that is opened from this location will have macros automatically enabled.
![](/uploads/1/2/7/7/127720295/316475764.jpg)