Macro security message pop up

[sgodse]

Is there any way I can have the security message not pop up that asks t
disable macros? This usually comes up if the security level is high.
also have the excel cells password protected, but not sure if tha
impacts the warning or not. Thanks

 

[Frank Kabel]

Hi
if you set the security level to 'Low' you won't get these warning
message. BUT I wouldn't recommend doing this as this is considered a
security feature

 

[Gord Dibben]

The message also comes up if security is set to "medium".

Before setting my security to "low" and running the risk of virus infection, I
would investigate the use of a "digital certificate".

If file is for your use only, check out "self cert" in Help.

You can run Self Cert from the Start>Programs>MS Office>MS Office Tools

Then see Help on "certificates" and "add a digital certificate to a file or
VBA project".

Gord Dibben Excel MVP