How do you add a digital certificate signature box in Excel?

Hi,

follow the steps
Click Start and then click All Programs> Microsoft Office> Microsoft Office Tools> Digital Certificate for VBA Projects.
The Create Digital Certificate dialog box appears.
Type the name you want to give your certificate.
click OK. Excel creates a Personal Digital Certificate.

And useful links to U-

http://www.x-eng.com/XSteam_Excel_install.htm
http://sourcedaddy.com/ms-excel/create-digital-signature-to-macro.html

by
kumaresan

This is for Office Excel 2010:

Open the Playground (or whatever it's name is) Click INFO-> and then click the small down arrow in the PERMISSIONS box.

Select "ADD a Digital Signature".

Depending on if you have a digital signature that is local, or provided for you by verisign etc. you can proceed, Click OK and select your signature from the list of available ones.

Note MS provides you with a selection of Signature Providers if it is to leave the company and you want it to be verifiable...

regards

I don't think anyone really understands what I'm trying to do.

-I want to program a box on a form created in Excel.

-Users filling out this form will click on the box and be prompted for a certificate.

-The certificate they use will be pregenerated and already on a smart card.

-After choosing the appropriate certificate the info for said cert, including user name and date/time signed, will be displayed in the box.

-This form can then be forwarded to a different user who will sign in a different, identically programmed box.

I am not trying to simply sign the entire document or add a signature to a macro for security purposes. This will serve as a non-repudiation and approval tool.

Note: This only works on machines that allow execution of macros.