Datasheet

Book VIII
Chapter 1
Building and
Running Macros
Macro Security
709
The Macro Settings tab of the Trust Center dialog box also contains these
other option buttons you can select:
✦ Disable All Macros without Notification to disable all macros not saved
in one of your computer’s trusted locations and all security alerts so
that you and the other users of the worksheet have no way to ignore the
alert and run the macro. Select this option when you don’t trust some-
one else’s macros and want to make it impossible to run a macro carry-
ing a computer virus.
✦ Disable All Macros except Digitally Signed Macros to automatically
enable digitally signed macros from a publisher that you’ve indicated
is trustworthy and to disable all macros that are not digitally signed
without notification. When you select this option and you try to run a
digitally signed macro that’s not from a publisher you’ve indicated is
trustworthy, Excel displays an alert in the message bar with a Trust All
Documents from this Publisher button that you can select, thereby
adding the publisher to the trusted list.
✦ Enable All Macros (Not Recommended; Potentially Dangerous Code
Can Run)
to throw all caution to the wind and allow all macros to run in
any worksheet you open — this is one option you never ever want to
select!
To change the trusted locations on your computer, you need to click the
Trusted Locations tab in the Trust Center dialog box. You can then use these
options to change the location settings:
✦ Add New Location: Use this command button to open the Microsoft
Office Trusted Location dialog box where you select a new folder on
your computer as a trusted location either by entering its directory path
name in the Path text box or selecting it with the Browse button. Click
the Subfolders of This Location Are Also Trusted check box to select it if
you want all subfolders within the designated folder to be included as
trusted locations.
✦ Allow Trusted Locations on My Network (Not Recommended): Select
this check box so that you can designate folders to which you have
access on your local network as trusted locations using the Add New
Location command button (as described in the immediately preceding
bullet point).
✦ Disable All Trusted Locations, Only Files Signed by Trusted
Publishers Will Be Trusted:
Select this check box to immediately dis-
able all the folders currently designated as trusted locations and allow
only macros from publishers designated as trustworthy to run in Excel.
36_037385 bk08ch01.qxp 11/27/06 1:35 PM Page 709