Table 1-1.Macro Security Settings
Setting Purpose
Disable all macros without notification Use this setting if you don??™t trust the source of
a workbook containing macros.
Disable all macros with notification This is the default setting. Use it when you
want macros to be disabled, but you want to
get security alerts if there are macros present.
You can decide when to enable those macros.
Disable all macros except digitally signed macros This is the same as the ???Disable all macros
with notification??? option, except that when
the macro is digitally signed by a trusted publisher,
the macro can run if you have trusted
the publisher.
Enable all macros (not recommended, potentially Use this setting to allow all macros to run.
dangerous code can run)
Trust access to the VBA project object model This setting is for developers only.
nCaution The ???Enable all macros??? setting makes your computer vulnerable to potentially malicious code.
It is not recommended that you use this setting permanently. For the examples in this book, we use this setting,
but it is highly recommended that you choose another option in your production code.
Trusted Publishers
This section lists the currently trusted certificates that can be used by developers to sign
documents and add-ins. When you open a digitally signed document, the digital signature
appears on your computer as a certificate. The certificate names the VBA project??™s source,
plus additional information about the identity and integrity of that source.
Pages:
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32