SelfCert Problem

[MWE]

I have used the selfcert approach to eliminate the constant warnings re macros and applications. It works fine except when you have multiple computers. I have two computers that I use a lot. One is a desktop and the other is a laptop. The former is the "primary" and the laptop is used when ever I am away from home. They are set up identically and I sync the data files on the two machines whenever I switch from one to the other. I have run selfcert on each of them.

When I switch from one computer to the other and start up something with macros that was recently synced, I get a error because the digital signatures do not match (see attached). The OpSys assumes that it is a virus and disables the macros. I then reset the digital signature for the file and it is fine until I sync it again and have the same problem on the other machine.

Does anyone know a way around this? How does one create a certificate that can be used on multiple machines?

Thanks

[stanl]

This might help

http://www.source-code.biz/snippets/vbasic/3.htm

[Sebastian H]

I just got the same error message:

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 the document. Macros will be disabled.
However, it's not the same solution as above, because I'm only using one computer.

Actually, this was the first time I tried out the digital signature. I did nothing but this simple sequence:
1. create signature
2. signed in VBIDE
3. saved the document
4. reopened it

The solution was to remove the signature and add a new one. (I was surprised that I could still do this, after Excel said it had disabled everything.) So I guess this must have been just a hiccup of the certification utility.

I'm posting this mostly so others won't get a heart attack when they read the misleading message "Only a macro virus would cause this."

Two questions are still open, though. If anyone happens to know the answers, it would be nice to know, but please don't spend more time on it than it takes to write a line of text or to add two links, because nothing depends on them:

In the process of trying to fix the problem, I created another signature, also for my own name. So now I have two signatures which I can not distinguish from each other. I don't think it does any harm, but is there a way to remove one of them?

I also noticed another error message:

This CA Root certificate is not trusted because it is not in the Trusted Root Certification Authorities store.
What is that store, and how do you get certificates there, if Digital Certificate for VBA projects doesn't do it?

Sebastian
(using XL 2003 on Win XP)