Getting Started With Excel Macros

Assigning a certificate you create with SelfCert.exe to a project indicates the project is self-signed and not authenticated. This option works well for personal workbooks. However, if you plan to distribute your workbook to other users you probably want to consider acquiring a true digital signature file. When you use a commercial digital signature file, the digital ID attaches to the macro. The Digital ID remains with the macro, and —if someone alters the macro in any way—notifies the user when the user should not trust the macro. This ensures that a macro you create does not harm another person's machine.

The most common location for obtaining a digital certification is from VeriSign, Inc. Of course, to obtain a commercial certification, you have to submit an application and pay the appropriate fee. You can find out more about obtaining a digital certification for your macro at www.verisign.com. Another company that you can contact for a digital ID is Thwate Consulting. You can find out about their digital signature options at:www.thwate.com.

Addrers

_I Inlernel Explorer

D nlerVideo

S-Q Jasc Software I no ffl-Pl Macromedia

-C] Messenger

—C] Microsoft ActiveSyr a-C] microsoft frontpage S-Q Microsoft Hardware - _| Microsoft Office to media .*. _J Office

_I Stationery

!+l-Pl Templates -Zj Microsoft Picture It! SHZ] Microsoft SOL Serv ¿-C] Microsoft Visual Stu— Microsoft Works Microsoft Works Su —Pi Motive i+l-Pl Movie Maker -CJ MSN

EB-C] MSN Gaming Zone -C] MSNDELL

LQt J

SELFCERT

Application

ROCKY RTFHTML RXCBPRW SAEXT.DLL @ @ ff @

SENDT0.DLL SEQCHKIO... SETLANG SIGNER.DLL

SQLPARSE... THDIC TRIGRAM UCSCRIBE

ill® U SPD AT 10 USPMAP USPTYPES UTILITY

VIEWSSRC Visual ui VTIDB VTIDISC

VTIPRES WAVTOASF WDBIMP.DLL WEBPAGE

Type: Application Size: G

CREATE A PERSONAL SECURITY CERTIFICATE

D Open Microsoft Windows Explorer.

L-H Click the Office10 subfolder of the Microsoft Office folder.

Note: If you performed a typical Office XP installation, Excel locates your program files in C:\Program Files\Microsoft Office.

L-H Double-click the SelfCert.exe program file.

■ The Create Digital Certificate dialog displays.

■ The Create Digital Certificate dialog displays.

■ Excel creates a digital certificate.

Note: See Chapter 2 to assign the certificate to your macros.

0 0

Post a comment