Macro Pop Up Box

[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

 

[Frank Kabel]

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

 

[Gord Dibben]

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