Suppress disable/enable macros window

C

CM

Is it possible when opening a spreadsheet with macros to have it default to
'enable macros' so that the window does not appear?

Thanks!
 
F

Frank Kabel

Hi
this would require to set the security level to 'low' which I wouldn't
recommend. This is meant as a security feature :)
 
G

Gord Dibben

CM

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
 
C

CM

Thanks for your advice :)

Frank Kabel said:
Hi
this would require to set the security level to 'low' which I wouldn't
recommend. This is meant as a security feature :)
Click to expand...
 
Top