View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Helmer John Helmer is offline
external usenet poster
 
Posts: 1
Default Code Signing of Excel VBA projects

I purchased a class 3 code signing certificate from Thawte Inc. I am able to
sign and time stamp vba projects following Thawte's instructions. The signed
files open and run macros without alert with the system clock set 2 years
forward. The signing routine always fails in the following cases: A long
password is entered in the VBA project properties box where we lock it for
viewing; The vba locking password contains special characters (eg. ยง); When
the project is not fully compiled (I like to save the workbooks with
uncompiled code to reduce the stored filesize approx. 35% for up/down loads.
This seems to be consistant in Excel releases 2000, 2002 and 2003. I hope
someone knows. Please post.

Thank You.

Sincerely,
Financial Reporting, Inc.
John Helmer
President