How can I use a self-signed Digital Certificate on two computers

I have a desktop and a laptop, both running Windows 7 and Office 2007. On the desktop I created some Excel VBA routines and functions that I want to use on both machines. I would rather not reduce the Macro Security in the Trust Center to "Enable all macros..." (i.e., I would rather keep the Macro Security at "Disable all macros except digitally signed macros").

I used Start>All Programs>Microsoft Office>Microsoft Office Tools>Digitial Certificate for VBA Projects to create a self-signed certificate, and it works fine on the Desktop where I created it.

How can I then copy the signed VBA projects to the laptop? I already used Start>Control Panel>Internet Options>Content>Certificates on the desktop to Export the certificate to a file, and then used the same command on the Laptop to Import the certificate. However, it will only go into the Trusted Publishers tab, not into the Personal tab.

Is there some way to share my own macros across my own two machines without reducing the Macro Security to an unacceptably low level or pay an authority for a certificate?

Thanks,

Dave

Originally Posted by 6StringJazzer

As a security feature, Microsoft Office does not allow self-signed certificates created on one machine to be accepted on another machine.

It might be possible to find another way to create a self-signed cert that would work, other than by using Microsoft's utility. I haven't explored that.

You can also use the security setting that prompts before allowing macros to run.

My situation with workbooks shared on a desktop and a laptop seems much too common. Who wants to be prompted every time they open a model? And, who would want to turn off all security to avoid such nagging prompts? I just feel I must be missing something. How do others deal with this???