Disabling Macro Warning

  • Thread starter Thread starter scojerroc
  • Start date Start date
S

scojerroc

How do I prevent the macro warning from popping up while retaining the medium
or high security level? Is it possible?
 
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.
 
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.
 
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.
 
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
 
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.
 
Unfortunately, the modules are protected (they're not mine), and I'm sent
dozens of these workbooks every day.
 
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."
 
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
 
Back
Top