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
Auto_Open Workbook_Open 4
Addin Auto_Open code executes only in debug mode 2
Auto_Open Code on Worksheet 2
Auto_open from Worksheet Object Code 1
Macro runs upon wkbk open, but no Workbook_Open or Auto_Open Macro 2
Unable to change ActiveSheet within Workbook_Open 2

Top