How to prevent Open macros to run

vemaju · December 5th, 2003, 06:51 AM

I want to open an Excel-file that contains WorkBook_Open macro.
I know the key SHIFT manually.
But I want to open it programmattically and prevent Open macro to run automatically ??

Thanks

pgtips · December 5th, 2003, 08:10 AM

I'm pretty sure that if you open it programatically using the Excel object library the auto-open macros don't run unless you specifically add another line of code to run them.

chrislepingwell · December 5th, 2003, 08:20 AM

Auto_nnn macros won't run, but the events will still fire, so if you're being good, and following the new event driven model (eg using Workbook_Open) you have to turn of the event handling before opening.

Code:

Application.EnableEvents = False
...
open files etc
...
Application.EnableEvents = True

And this works for any event with the application

HTH
Chris

There are two secrets to success in this world:
1. Never tell everything you know

vemaju · December 5th, 2003, 09:19 AM

It works fine. Thanks.

spicetrader · June 7th, 2013, 12:26 PM

Quote:

Originally Posted by chrislepingwell

[...]following the new event driven model (eg using Workbook_Open) you have to turn of the event handling before opening.

Code:

Application.EnableEvents = False
...
open files etc
...
Application.EnableEvents = True

And this works for any event with the application

What is an "event" in VBAspeak?
Is running a macro an "event"?
Is invoking Application.Run an "event"?