Datasheet

11
Chapter 1: Using Macros and Form Controls
6
7
4
5
If you have Macro Security enabled, Excel displays the
Trust Bar below the Ribbon when you open a workbook
containing a signed macro. You can modify the
workbook, but you cannot use the macros. If you trust
that the document is safe, you can click the Enable
Content button on the Trust Bar to enable the macros
in the workbook. The workbook then becomes a trusted
document and you will not need to enable the
workbook again.
You can use the Microsoft Office Security Options
dialog box to select the security option you want. On
the Trust Bar, click Macros Have Been Disabled.
Security warning options appear. Click the Enable
Content button. A menu appears. Click Advanced
Options. The Microsoft Office Security Options dialog
box appears. Click Help Protect Me from Unknown
Content (Recommended) to disable the macros; click
Enable the Content for This Session to enable the
macros for one session; or click Trust All Documents
from This Publisher to add the macro publisher to the
Trusted Publisher list. Excel does not display a warning
when you open workbooks with macros if the publisher
is on the Trusted Publisher list.
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.
The Digital Signature dialog box
appears.
4 Click Choose.
7 Click OK to close the Digital
Signature dialog box.
Excel attaches the digital signature
to your workbook.
Note: To return to Excel, press Alt+Q.
03_591598-ch01.indd 1103_591598-ch01.indd 11 6/11/10 1:41 PM6/11/10 1:41 PM