View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Erich Neuwirth Erich Neuwirth is offline
external usenet poster
 
Posts: 41
Default Auto_Open and Workbook_Open

I ran into trouble with Auto_Open and Workbook_Open
Workbook_Open, the officially recommended method
for executing macros automatically when
opening a workbook, does not work when
Application.EnableEvents = False

Auto_Open, on the other hand, always seems to be run.
I have some (protected) addins (not written by me) which rely on
workbook_open to be executed.
It seems that one of these addins is setting
Application.EnableEvents = False
Anyhow, when ich check EnableAddins after starting Excel, it is false.

So I tested if for one workbook Auto_Open is executed
before Workbook_Open. Then, Auto_Open could set
Application.EnableEvents = True
and then WorkBook_Open would be executed.
This does not work. It seems that if at all
Workbook_Open is executed before Auto_Open.

Is there a way to ensure execution of Workbook_Open
in a Workbook where one can not change the code?