Why is the Excel Addin the Activeworkbook

[Martin in Frisco Texas]

Why is the Excel Addin the Activeworkbook. The IS Addin is set to true, but
the Addin is the active workbook when called by a Auto_Open macro from a
workbook until the Auto_Open macro is finished?

[Vacation's Over]

Maybe because it is "active" opening itself??

Any workbook can be the "activeworkbook"

This is why we use Thisworkbook within addins so it is clear that we are
refering to the wb that has the code in it.

Depending on why this bothers you you may want to assign a variable to your
original wb and then call it by name

dim myWB as Workbook
set myWB = Activeworkbook
auto_open some addin
myWB.dosomething


"Martin in Frisco Texas" wrote:

> Why is the Excel Addin the Activeworkbook. The IS Addin is set to true, but
> the Addin is the active workbook when called by a Auto_Open macro from a
> workbook until the Auto_Open macro is finished?

[Martin in Frisco Texas]

Vacations Over

Thanks

Martin

"Vacation's Over" wrote:

> Maybe because it is "active" opening itself??
>
> Any workbook can be the "activeworkbook"
>
> This is why we use Thisworkbook within addins so it is clear that we are
> refering to the wb that has the code in it.
>
> Depending on why this bothers you you may want to assign a variable to your
> original wb and then call it by name
>
> dim myWB as Workbook
> set myWB = Activeworkbook
> auto_open some addin
> myWB.dosomething
>
>
> "Martin in Frisco Texas" wrote:
>
> > Why is the Excel Addin the Activeworkbook. The IS Addin is set to true, but
> > the Addin is the active workbook when called by a Auto_Open macro from a
> > workbook until the Auto_Open macro is finished?

[Ethan Strauss]

Note quite the same, but related. I can't get the an AddIn to run an macro
when a workbook opens. I have tried a number of different configurations
(Workbook_Activate, App_Activate, Workbook_Open, and others) and none of them
trigger when I open Excel with the AddIn running.
I have thought that part of the problem is that the AddIn Workbooks is never
really running. I am not sure.
I would appreciate any help.
Thanks,
Ethan

"Vacation's Over" wrote:

> Maybe because it is "active" opening itself??
>
> Any workbook can be the "activeworkbook"
>
> This is why we use Thisworkbook within addins so it is clear that we are
> refering to the wb that has the code in it.
>
> Depending on why this bothers you you may want to assign a variable to your
> original wb and then call it by name
>
> dim myWB as Workbook
> set myWB = Activeworkbook
> auto_open some addin
> myWB.dosomething
>
>
> "Martin in Frisco Texas" wrote:
>
> > Why is the Excel Addin the Activeworkbook. The IS Addin is set to true, but
> > the Addin is the active workbook when called by a Auto_Open macro from a
> > workbook until the Auto_Open macro is finished?