load event when specific workbook is opened

[itsthebike]

After reading many threads on this topic, I still can't come up with the
proper coding to do what I want to do. When I open a specific workbook,
I'd like for a specific event to be active as long as that workbook is
the active one, and I'd like that specific event to activate for any
worksheet within the workbook.

I have used the Auto_Open event, and I thought I should call the
Workbook_Activate event from the Auto_Open. This doesn't seem to be
working. Suggestions for a workable solution??

 

[NickHK]

Not sure what you mean by "specific event to be active as that workbook is
the active one". An event cannot be active. It is something you respond to
by putting code in its signature.

If that WB is not active, its Workbook_SheetActivate will not fire.
Unless you turn off events (Application.EnableEvents=False) all events are
available in the active WB/WS depending where the code resides.
If you use Application Level Events
(http://www.cpearson.com/excel/AppEvent.htm) the whole of Excel is available
to you.

NickHK

 

[itsthebike]

Nick,
Thanks for your reply. As a relative VB novice, please pardon my
incorrect terminology. What I'm trying to accomplish is something
similar to the following:

Sub Workbook_Open()
''Call the 'sub'
Workbook_Activate
End Sub

-------------------------------
Sub Workbook_Activate()
Workbook_Activate
End Sub

-------------------------------
Sub Workbook_Deactivate()
Workbook_Deactivate
End Sub

= = = = = = = = = = = = = = = =

What I need to happen is:
- target WB is opened
- then, anytime any WS in the target workbook is the active WS, then
have the code identified as "xWorkbook_Activate" (above) be activated
once a certain action takes place (i.e. cursor moves based on an entry
being made in a specific column). Hopefully this adds more
understanding to the nature of the issue. Thanks.