Problem Code Signing a VBA Macro in an Excel 2002/2003

From: Stephen Davies (StephenDavies_at_discussions.microsoft.com)
Date: 11/18/04 

Date: Thu, 18 Nov 2004 01:09:07 -0800

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 spread*** 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 work***. In Excel 2002 the spread***
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 ***, edit the VBA project and view the
digital certificate nothing is install and of course the spread***
complains about the macros not being signed on medium & high security setting.

Whats going wrong here, it all worked will with the TEST self signed
certificate, I just now need to do the real thing. 

-- 
Regards
Stephen Davies
Loading