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.

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