Macro Pop Up Box

  • Thread starter Thread starter STOMPFROG
  • Start date Start date
S

STOMPFROG

When opening an excel chart with macros there is a pop up box which ask
if you would like to enable / disable the macros. is it possible to sto
this box coming up every time?

cheers

chri
 
Hi
as this is a security featur you would have to set the security level
to<'Low' (Tools - Macros - security).
BUT I wouldn't recommend doing this
 
Frog

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
 
Back
Top