Microsoft Office Tutorials and References
In Depth Information
Create a Trusted Location for Opening Files
Chapter 10: Maximizing Excel Security and Privacy
If you have the Developer
tab displayed, a quicker
way to open the Trust
Center is to click the
Developer tab and then
click Macro Security (
5 Click Trusted Locations.
6 Click Add New Location.
7 Type the full path of the
folder you want to set up
as a trusted location.
You can also click Browse
and then use the Browse
dialog box to select the
If you also want
subfolders to be trusted,
click to select the
Subfolders of this
Location Are Also Trusted
8 Type a description for the
9 Click OK.
0 Click OK in the bottom
right-hand corner of the
Trust Center dialog box
! Click OK in the Excel
Options dialog box (not
By default, Excel does not allow you to
specify a network path as a trusted location.
If you routinely open macro-enabled
workbooks from a network location, you
can configure Excel to allow network shares
as trusted locations. Follow steps 1 to 5 to
display the Trusted Locations tab, and then
click to select the Allow Trusted Location on
My Network check box.
If you no longer use a trusted location
for macro-enabled workbooks, you
should remove the folder from the
Trusted Locations list as a security
precaution. Follow steps 1 to 5 to
display the Trusted Locations tab, click
the trusted location you no longer
require, and then click the Remove