"Always trust macros from this publisher" is greyed out in Excel

[Guest]

I'm using Excel 2003 in high security mode. I've generated a certificate
using selfcert.exe, signed a spreadsheet with a macro, saved and then reopend
it. When I open the file, I get the Security Warning dialog box and the only
thing I can do is disable the macro because "Always trust macros from this
publisher" is greyed out.

This is all being done on the same computer as the same user. When I choose
Tools | Macro | Security, "Trust access to Visual Basic Project" is checked,
but greyed out too. If I and manually export the certificate and then import
it into "Trusted Publishers", the macro will run, but I'm trying to come up
with a simpler process for some of my less sophisticated users.

 

[Nigel]

This might help ?

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=194

 

[Guest]

Thanks for the link, but that procedure just installs the certificate as a
trusted root certificate, but the "Always trust.." box is still greyed out.
The trick is that the certificate needs to be installed as a Trusted
Publisher for the macro to run. I'm just looking for a simple way of doing
that, without having to teach a user how to import the certificate into the
correct store.
If the "Always Trust.." box wasn't greyed out, that would work or if I could
find some way to script the addition with little or no user input required, I
would be happy.