Auto_Open and Workbook_Open in Addins

E

Erich Neuwirth

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.
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto_Open and Workbook_Open 1
Mysterious auto_open 1
Addin Auto_Open code executes only in debug mode 2
Auto_Open Code on Worksheet 2
Auto_Open Workbook_Open 4
model in excel: auto_open and in thisworkbook workbook_open 0
Unable to change ActiveSheet within Workbook_Open 2
Private Sub Workbook_Open() 1

Top