Auto_Open and Workbook_Open in Addins
 

I have an addin which contains a Workbook_Open macro in
the code sheet for the workbook (which by the is not named
ThisWorkbook)
This code is not executed when Excel is started
and the addin is automatically loaded.
Auto_Open macros are executed.
What might be the reason for this?
It seems that this only happens on some machines,
but not on other machines.

Auto_Open and Workbook_Open in Addins
 

Workbook_open is an event that belongs to the workbook. It wants to be in the
ThisWorkbook module.

Move it and it should execute ok.


Erich Neuwirth wrote:

I have an addin which contains a Workbook_Open macro in
the code sheet for the workbook (which by the is not named
ThisWorkbook)
This code is not executed when Excel is started
and the addin is automatically loaded.
Auto_Open macros are executed.
What might be the reason for this?
It seems that this only happens on some machines,
but not on other machines.

--

Dave Peterson