load event when specific workbook is opened

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??

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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??
>
>
> --
> itsthebike
> ------------------------------------------------------------------------
> itsthebike's Profile:
http://www.excelforum.com/member.php...o&userid=27425
> View this thread: http://www.excelforum.com/showthread...hreadid=559201
>

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.