LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Code signing a VBA macro in 2002 and 2003

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Having Trouble Digitally signing a macro JHL Excel Discussion (Misc queries) 0 August 31st 08 07:13 PM
Signing VBA code within an Excel spreadsheet from VBA Martin Waller Excel Programming 3 September 7th 04 12:29 PM
Excel 2002/2003 Macro Compatibility issue Steve[_64_] Excel Programming 0 July 23rd 04 03:05 AM
Code-signing certificate problems in Excel 2000 with Windows 2000 Aaron Queenan Excel Programming 0 May 6th 04 11:35 AM
VBA Code Signing Bruno Guillemette Excel Programming 0 July 25th 03 08:41 PM


All times are GMT +1. The time now is 01:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"