The macros in this file do not match the digital signature.

[Reto Laemmler]

Hi,

I just bought a Verisign code signing certificate. I have a workbook
containing VBA macros created with Excel 2003. I signed the macros using my
Verisign certificate. Now when I open this workbook modify and close it about
3 times it suddenly brings an error saying: "The macros in this file do not
match the digital signature. Only a macro virus would cause this. Please
scan for viruses, and notify the publisher of this document. Macros will be
disabled."
The lesser macros the workbook contains the smaller is the chance of this to
happen. I found a KB by Microsoft which is not quite what my problem is (I
don't create it from a template) but similar:
http://support.microsoft.com/default.aspx?scid=kb;en-us;896715

In all the newsgroups many people complain about this but no solution seems
to be around.

Any help is highly appreciated.

Best regards,
Reto
www.xcellery.com

 

[rlaemmler]

Hi,

I found the reason for this problem. My macros included some runtime VB
script compilation. As soon as I don't compile the VB script during
runtime the digital signature doesn't invalidate anymore.

Reto
www.xcellery.com