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

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.

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

This might help ?

http://pubs.logicalexpressions.com/P...cle.asp?ID=194

--
Cheers
Nigel



"TimE" wrote in message
...
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.

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

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.

"Nigel" wrote:

This might help ?

http://pubs.logicalexpressions.com/P...cle.asp?ID=194

--
Cheers
Nigel



"TimE" wrote in message
...
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.