MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Is there a way to stop the "Enable Macros" dialog when opening Excel files?


Posted by Mike O on April 09, 2001 8:50 AM

Answering this question every time can be annoying. The file is used by only a small number of people in the same location and this message gets annoying after a while. Anybody know how to diable it and still have the VBA code run?
Thanks


Posted by Joe on April 09, 2001 9:02 AM

Mike,
Under Tools->Options->General,uncheck the Macro virus protection box.

Joe

Posted by S N on April 10, 2001 7:27 AM

Does this exist in Excel 2000? I've been told to do this in Excel 97, but i've yet to find it from a new version of Excel that was installed with Office 2000.

Posted by David Megnin on April 13, 2001 3:44 PM

I need a way to disable the "Enable Macros" dialog for a customer loading an order form to prevent them from disableing macros. If they disable macros the for won't work. It would be O.K. to just exit the form if they don't enable macros also, but I would prefer macros are just enabled without asking.
***We will not be asking all our customers to go to Tools->Options->General and uncheck the Macro virus protection box.
Thanks in advance. Answering this question every time can be annoying. The file is used by only a small number of people in the same location and this message gets annoying after a while. Anybody know how to diable it and still have the VBA code run?

Posted by Steve on April 30, 2001 12:51 AM

I just found a way in 2000

Hello,
I just found a way to do it in 2000. Go to Tools, Macro, Security and change the security level to low and this keeps the macros enabled, but doesnt ask yuo the question upon opening.
Cheers
Steve