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

T

TimE

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.
 
T

TimE

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top