Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have obtained a Digital Code Signing certificate from Comodo (InstantSSL)
and installed it in my Certificate Store. It has a 1024 bit key using Microsoft Enhanced Cryptographic Provider v1.0. After opening my Excel spreadsheet I edit the macros (Alt-F11) click on the project and select Tools|Digital Signatures. From here Choose my certificate and click OK, this informs me that the VBA project is currently signed by my company (viewing the cert shows it was issued by Comodo). Close the VBA editor and save the worksheet. In Excel 2002 the spreadsheet closes without question. In Excel 2003 I receive the message -------------------------------------------- There were problems with the digital certificate. The VBA project could not be signed. The signature will be discarded. -------------------------------------------- When I open either the 2002 or 2003 sheet, edit the VBA project and view the digital certificate nothing is install and of course the spreadsheet complains about the macros not being signed on medium & high security setting. Whats going wrong here, it all worked well with the TEST self signed certificate, I just now need to do the real thing. -- Regards Stephen Davies |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Having Trouble Digitally signing a macro | Excel Discussion (Misc queries) | |||
Signing VBA code within an Excel spreadsheet from VBA | Excel Programming | |||
Excel 2002/2003 Macro Compatibility issue | Excel Programming | |||
Code-signing certificate problems in Excel 2000 with Windows 2000 | Excel Programming | |||
VBA Code Signing | Excel Programming |