Personnal certificate problem

[Pierre Archambault]

Hi everybody

I am running Excel 2000 on Win2K (French) and I create worksheets that
contains some VBA code.

I use these files myself and I do some other worksheets for my brothers,
sisters, and friends.

To give them some security, I sign the macros with my own personnal
certificate wich I created with the "SELFCERT.EXE" utility. When we open
those worksheets, we have to accept to trust my code and add my certificate
to the trusted certificates list.

I don't know what happened to one of my files but now, when I open it, I
receive this message: (The message is in french but I will try to translate
it.)

"Macros contained in this file do not match the numeric signature. Only a
virus can cause this. Please run an Anti-Virus and let the editor of the
document know about it. Macros will be deactivated."

I know that I do not have any virus on my PC. I have a firewall, a good
Anti-Virus and I never open a joined file in my email client.

At that point the only way I found to make the code run again is to remove
the signature, sign it again, save the file, unload it and reload it again.
But this process only work once. As soon as I run the code again and save
the file, the next time I try to open it, I receive the same message and I
have to do this hole process over again.

Please someone help me with this problem?

Thanks

Pierre Archambault

 

[iwrk4dedpr]

I'm not sure what causes this issue. But I have this proble
constantly.

Like you I have to remove and resign the project when I get the error.
It usually happens after I've done some work.

I have noticed that if the workbook is opened ReadOnly and you work o
the VBA code and then change the file access back to ReadWrite i
doesn't like the certificate either.

Please let me know if you get a reason why this happens. I've bee
living with this issue for 4 years now.


Barr