Disabling Macro Warning

[scojerroc]

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

 

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

 

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

 

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

 

[Gord Dibben]

Just get rid of the macros and any modules they reside in.

http://www.contextures.on.ca/xlfaqMac.html#NoMacros


Gord Dibben MS Excel MVP

 

[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

 

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

 

[scojerroc]

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

 

[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."

 

[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