Digital signatures

[Carlos]

Hello everyone,

Do you know how to attach a digital signature to a workbook. I designed an
Add-In that validates the workbook, and I want the last macro to digitally
sign it if the validation process is successful. I've seen the help files but
they only contain information about how to do it in Word and the 'signature'
and 'signatureset' classes are not part of Excel's library.

Thanks in advance,

 

[JLGWhiz]

I got this by going to the search feature in the start menu. It took me to a
Microsoft bulletin:

You can also use a digital signature that is created with Microsoft
Certificate Server. Certificate Server is included with Microsoft Windows NT
4.0 Option Pack, with Microsoft Windows 2000 Server, and with Microsoft
Windows Server 2003.

For more information, go to the Help and Support search feature through the
Start menu.

 

[NickHK]

Carlos,
If you mean digitally sign a VBA project in code from Excel/VBA, I don't
think you can, unless you can get SendKeys to work.
Maybe later versions, 2003 and up, have some possibility but....

NickHK

 

[Carlos]

Thanks a lot for the comment NickHK. It's a shame that digital signature
objects are not part of .xls, something I suspected while searching on .xls'
library, because those objects do not appear there.

I've just confirmed that in the following book
Title: Excel 2003 VBA Programmer's Reference
Author: Paul Kimmel et al.
ISBN:0764556606

Cya!