Disabling Macro Warning


S

scojerroc

How do I prevent the macro warning from popping up while retaining the medium
or high security level? Is it possible?
 
Ad

Advertisements

S

Stan Brown

Tue, 18 Dec 2007 12:18:03 -0800 from scojerroc
How do I prevent the macro warning from popping up while retaining the medium
or high security level? Is it possible?

If macros are digitally signed, the warning won't appear.

Instructions have been posted here for digitally signing your own
macros, but unfortunately that feature doesn't work for me.
 
S

scojerroc

I dont want the macros to run. I want to disable the code entirely.
I'm just tired of hitting the N key every time I open these worksheets.
 
J

Jim Thomlinson

If your security is set to high then you will not get a warning. Macros will
be disabled by default...

If you wish to retain your medium setting then there is nothing you can do
about the warnings. That is the whole point to the medium setting.
 
G

Gord Dibben

Just curious Stan.

Will the SelfCert tool not work for you?

What happens when you try?

What steps do you take to sign each workbook's VBA Project?


Gord Dibben MS Excel MVP
 
Ad

Advertisements

S

scojerroc

When I set it to high, I get a message telling me that it's been disabled.
I'm trying to avoid any message altogether.
 
S

scojerroc

Unfortunately, the modules are protected (they're not mine), and I'm sent
dozens of these workbooks every day.
 
S

Stan Brown

Tue, 18 Dec 2007 14:19:18 -0800 from <Gord Dibben
Just curious Stan.

Will the SelfCert tool not work for you?

What happens when you try?

"An error occurred during certificate creation. Selfcert was unable
to create your certificate."
 
Ad

Advertisements

G

Gord Dibben

Never run across this.

Do you have Administrator privileges?

Although, I tested with my wife's limited user account and was able to create a
selfcert digital certificate so it seems being Admin is not an issue.


Gord
 

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