Enable Macro on open

  • Thread starter Thread starter Lime
  • Start date Start date
L

Lime

Is the a code to enable macros when the file is opened, rather that having to
click enable macro? any help appreciated..
Thanks...
 
Hi,

Go in Tools, Macro, Security

In the security level tab select low.

Reopen the workbook and it will not ask you to enable the macro.

Regards

Heera
 
And leaves you vulnerable to malicious code.


Gord Dibben MS Excel MVP
 
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

Just switched to Excel 2007 from 2003 - Unclear how to enable macros 2
Run Macro If Cell have "x" value 0
To Enable Macro in Excel. 2
Macro Activation 2
security, enabling macros to enable a disabling saving function 12
vba code to enable macros 3
How to Unlock Excel Workbook protected by MACRO Password 6
Macro Enable after Disabled 1

Back
Top