SEARCH
0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Prev | Current Page 21 | Next

Jim DeMarco

"Pro Excel 2007 VBA"

A digital signature
does not necessarily guarantee the safety of a project, and you must decide whether
you trust a project that has been digitally signed. If you know you can always trust macros
from a particular source, you can add that macro developer to the list of trusted sources
when you open the project.
Trusted Locations
This is where you can define trusted locations. These are folders on your PC or network where
files with macros can be stored. Excel will trust any document in a folder designated as trusted
and will run any macros in those files.
CHAPTER 1 n THE MACRO RECORDER AND CODE MODULES 2
nCaution Be careful when defining trusted locations! Documents in trusted locations can run without
being checked by the Trust Center security system. If you add or change a location, make sure the new
location is secure.
The Remove Button
If you added a certificate to your list of trusted publishers when you first opened a VBA project
signed with that certificate, and later choose not to trust that publisher, you can use the
Remove button to remove the certificate from your list of trusted publishers. The next time
a project signed with that certificate is opened, the virus protection behavior corresponding
to the setting on the Security Level tab will occur.
The Remove button in the Trusted Locations section lets you remove locations from the
list in the same manner.
Lowering the Security Level
Before you can begin recording and playing back macros, you must lower the macro security
level.


Pages:
9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33