Datasheet

7
Chapter 1: Using Macros and Form Controls
1
6
2
5
4
3
7
The Create Digital Certificate dialog box
appears.
6 Type the name you want to give your
certificate.
7 Click OK.
Excel creates a Personal Digital
Certificate.
1 Click the Start button.
2 Click All Programs.
3 Click Microsoft Office.
4 Click Microsoft Office Tools.
5 Click Digital Certificate for VBA Projects.
Create a Digital Signature
remains with it; if anyone alters the macro, Excel notifies
the user that the macro should not be trusted. The most
common provider of commercial digital certification is
VeriSign, Inc. To obtain a commercial certification, you
must submit an application and pay a fee. You can find
out more at www.verisign.com.
To view the certificates in your Personal Certificate store,
open Windows Internet Explorer. On the Internet Explorer
menu, click Tools and then click Internet Options. The
Internet Options dialog box appears. Click the Content
tab. Click the Certificates button. The Certificates dialog
box appears. Click the Personal tab. All of your personal
certificates appear.
I
f you create a workbook that contains macros,
you should consider using a digital signature. A
digital signature provides assurance that no one
has altered the macro. You can create a personal
digital signature by using the Digital Certificate for
VBA Projects tool. Digital signatures created with the
Digital Certificate for VBA Projects tool work only on
the computer on which the digital signature was
created.
If you plan to distribute your workbook to others,
you should consider acquiring a commercial digital
signature. When you use a commercial digital
signature, the digital ID attaches to the macro and
Create a Digital
Signature
03_591598-ch01.indd 703_591598-ch01.indd 7 6/11/10 1:41 PM6/11/10 1:41 PM