Datasheet

6
3
4
1
2
The Trust Center dialog box appears.
3 Click a macro security setting
(
changes to ).
4 Click OK.
Excel changes your macro security
setting.
1 Click the Developer tab.
Note: See the section “Introducing Macros”
to learn how to display the Developer tab.
2 Click Macro Security.
Set Macro Security
the macro but you have not opted to trust the publisher,
you can enable the macro or trust the publisher. See the
Extra section of “Assign a Digital Signature to a Macro”
in this chapter to learn how to trust a publisher.
The Enable All Macros (Not Recommended; Potentially
Dangerous Code Can Run) option enables you to run all
macros. Because potentially dangerous code can run,
Microsoft does not recommend this option.
Changes you make to macro security in Excel do not
change the macro security in other Office programs.
Macro creators use digital signatures to verify the safety
of the macros they create. You can create a digital
signature by using the Digital Certificate for VBA Projects
tool, or you can obtain a digital certificate from a
commercial certification authority. For more information
on the Digital Certificate for VBA Projects tool, see the
next section, “Create a Digital Signature.”
B
ecause of increasing problems with computer
viruses, specifically macro viruses, the default
Excel macro security setting disables all macros
when you open a workbook and enables you to decide on
a case-by-case basis whether you want to enable them.
This is true whether you created the macros or someone
else created them. You can change the Excel macro
security by choosing one of four options.
The Disable All Macros without Notification option
disables all macros. This option does not provide you
with any security alerts to let you know macros exist.
The Disable All Macros with Notification option is the
default setting. It notifies you if macros are present so
you can enable them on a case-by-case basis.
The Disable All Macros except Digitally Signed Macros
option disables all macros except those digitally signed by
a trusted publisher. If the publisher has digitally signed
Set Macro
Security
03_591598-ch01.indd 603_591598-ch01.indd 6 6/11/10 1:41 PM6/11/10 1:41 PM