blacklark
asked on
How do you add a digital certificate signature box in Excel?
I am trying to add a digital signature box to an Excel spreadsheet. The desired effect is to have a box that, when clicked, will prompt the user to choose a digital certificate to sign the document and will display said certificate, with signature date, in the box. Essentially provide the same functionality and convenience as the digital signature box in Adobe Acrobat.
What would I have to do to make this happen?
What would I have to do to make this happen?
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
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
ASKER
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.
-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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Note: This only works on machines that allow execution of macros.
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