Datasheet

Set Macro
Security
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 allows 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 setting. Excel
provides four options:
• Disable all macros without notification: This
option disables all macros and does not provide you
with any security alerts to let you know macros exist.
• Disable all macros with notification: This is the
default setting. It notifies you if macros are present
so you can enable them on a case-by-case basis.
• Disable all macros except digitally signed
macros: This option disables all macros except
those digitally signed by a trusted publisher. If the
publisher has digitally signed the macro but you
have not opted to trust the publisher, you can
enable the macro or trust the publisher. See the
“Extra” information in the section, “Run a Macro,”
to learn how to trust a publisher.
• Enable all macros (not recommended; potentially
dangerous code can run): This option allows 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 your own
digital signature by using the Microsoft Selfcert.exe tool,
or you can obtain a digital certificate from a commercial
certificate of authority vendor. For more information on
the Microsoft Selfcert.exe tool, see the next section,
“Create a Digital Signature.”
1 Click the Developer tab.
Note:
See the section, “Introducing Macros,” to learn how to
display the Developer tab.
2 Click Macro Security in the Code group.
1
2
3
4
Set Macro Security
6
The Trust Center dialog box appears.
3 Click to select a macro setting ( changes to ).
4 Click OK.
Excel changes your macro security setting.
04_132302 ch01.qxp 7/27/07 9:19 PM Page 6