Suppress disable/enable macros window

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Thanks!
 
Hi
this would require to set the security level to 'low' which I wouldn't
recommend. This is meant as a security feature :-)
 
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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disable Macro Alert 2
security alert on macro-enabled worksheet 2
EXCEL 2007 Macro Security Being Ignored 9
Display "macro-free workbooks - VB project message" on closing Exc 3
Excell 2000 macro will not open file! 1
Suppress Disable/Enable Macro Pop-Up Window 2
How to enable / disable re-calculation option? 3
Suppress Update Links Message 2

Back
Top