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
).
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
folder.
6
If you also want
subfolders to be trusted,
click to select the
Subfolders of this
Location Are Also Trusted
check box.
8 Type a description for the
folder.
9 Click OK.
0 Click OK in the bottom
right-hand corner of the
Trust Center dialog box
(not shown).
! Click OK in the Excel
Options dialog box (not
shown).
7
8
9
More Options!
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.
Remove It!
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
button.
 
Search JabSto ::




Custom Search