Datasheet

Chapter 1: Using Macros and Form Controls
11
If you have macro security
enabled, Excel displays a warning
just below the Ribbon when you
open a workbook containing a
signed macro. You can click the
Options button located next to
the warning to open the
Microsoft Office Security
Options dialog box, where you
can indicate that you trust the
publisher. Excel then saves the
name of the publisher in the
Trusted Publishers section of the
Trust Center.
If you click the Macro Security
button on the Developer tab, the
Trust Center dialog box appears.
Click Trusted Publisher to display
a list of your trusted publishers.
If you no longer want to trust
macros from a publisher listed
on the Trusted Publishers page,
click the name of the publisher
and then click Remove. The next
time you open a workbook with
a macro from a removed
publisher, Excel again warns you
about its macros.
Unless you have your macro
settings set to enable all macros,
Excel checks all documents you
open for macros. See the section,
“Set Macro Security,” for more
information. If you have a file
that you do not want Excel to
check, you can store it in a
trusted location. In the Trust
Center dialog box, click Trusted
Locations to define a trusted
location.
4
5
6
7
Denise E... Denise Eth... Code Signing None 1/1/2012
The Digital Signature dialog box appears.
4 Click Choose.
The Select Certificate dialog box appears.
Note: See the section, “Create a Digital Signature,” to
learn how to create a digital signature.
5 Click the signature you want to apply.
6 Click OK to close the Select Certificate dialog box.
7 Click OK to close the Digital Signature dialog box.
Excel attaches the digital signature to your
workbook.
04_132302 ch01.qxp 7/27/07 9:20 PM Page 11