Datasheet

10
2
3
3
1
The Visual Basic Editor appears.
3 Click Tools ➔ Digital Signature.
1 Click the Developer tab.
Note: See the section “Introducing Macros”
to learn how to display the Developer tab.
2 Click Visual Basic in the Code group.
Assign a Digital Signature to a Macro
A
digital signature provides assurance that a
workbook file that contains macros is valid and
no one has altered the macros. There are two
types of digital signatures: personal digital signatures and
commercial digital signatures. You can create a personal
digital signature by using the Digital Certificate for VBA
Projects tool, or you can purchase a digital signature. Refer
to the section “Create a Digital Signature” to learn how to
create a personal digital signature. After you create a digital
signature, you must attach it to your workbook. Attaching
a digital signature is similar to sealing an envelope. If an
envelope arrives sealed, you have some level of assurance
that no one has tampered with its contents.
Use the Digital Signature dialog box to attach a digital
signature. The Visual Basic Editor (VBE) is a separate
Excel module that you can use to edit your macros.
Access the Digital Signature dialog box by opening the
VBE. The Digital Signature dialog box lists valid
certificates. You can use the Digital Signature dialog box
to view certificates and to select the one you want to use.
Unless you have on your computer a valid digital
signature certificate for the signature used to sign a
macro, Excel removes the digital signature when you
modify a macro and you must reattach it. If you are not
sure if a workbook has a digital signature, you can check
the signature by reviewing the Digital Signature dialog
box. If a workbook has a digital signature, the name of
the signature appears in the Certificate Name field. If you
click the Remove button in the Digital Signature dialog
box, Excel removes the digital signature.
Assign a Digital
Signature to a Macro
03_591598-ch01.indd 1003_591598-ch01.indd 10 6/11/10 1:41 PM6/11/10 1:41 PM