How to check "Always trust macros from this published" when securityis set to high?

N

Nick

Hi,

I have created a custom cert in Office 2003 and attached it to VBA code.

On the computer (Office 2003) which create this cert, when excel
security is set to high, I was able to check "Always trust macros from
this published" and thus enable the macro.

Then I copy the same file to another computer, the security is also set
the high, but this time the "Always trust macros from this published" is
not checked. (grey out). How to check this box?

Thanks
Nick
 
J

JK

Nick,
Please tell me how you created your cert. Up to now I've been paying
Verisign a healthy sum to do it.

Regarding your issue, I don't know. Perhaps if you teach me how to create
the cert, we can solve the problem together.

Regards,
Jim Kobzeff
 
G

Gord Dibben

Nick

Self-certs are for use on one computer only. See Help on Certificates.

If you make it a "trusted certificate" through MMC and export the *.cer file
to the other computer, you will be able to use it.

Gord Dibben Excel MVP
 
N

Nick

Hi,

I got your point.

But is there any fast method for deploying these "trusted cert" on other
computers?

Thanks!

Nick
 
S

Stephen Bullen

Hi Nick,
I have created a custom cert in Office 2003 and attached it to VBA code.

On the computer (Office 2003) which create this cert, when excel
security is set to high, I was able to check "Always trust macros from
this published" and thus enable the macro.

Then I copy the same file to another computer, the security is also set
the high, but this time the "Always trust macros from this published" is
not checked. (grey out). How to check this box?
Click to expand...

In general, certificates created using selfcert are not trustable on other
machines. If this is only one or two machines, you might be able to export
the selfcert certificate using Start > Settings > Control Panel > Internet
Options > Content > Certificates and import it on the other machine, but
I've never tried it.

If you want to have a fully-trustable certificate, you'll need to buy one,
eg from www.thawte.com

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.ie
 

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

Similar Threads

Need Help with Macro Security 1
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
VBA code won't run, even with Macro Security set to Enable All Macors 9
Macro/Trust Center Settings 5
Want to have macro execute automatically when doc created 3
"Always trust macros from this publisher" is greyed out in Excel 2
Trust Center properties 0
Just switched to Excel 2007 from 2003 - Unclear how to enable macros 2

Top