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

From: Stephen Davies (steve_at_newsgroup.nospam)
Date: 11/24/04 

Date: Wed, 24 Nov 2004 15:55:02 -0800

The solution to this problem can be found at
http://support.microsoft.com/newsgroups/newsReader.aspx?dg=microsoft.public.excel.programming&mid=27f2c571-024c-409a-8163-87d21cd5df17

Regards
Stephen Davies

"Stephen Davies" wrote:

> 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