What I need to happen is:
- target WB is opened
- then, anytime any WS, in the target WB, is the _active_ WS
(regardless of how many other WB's are open), then have the code
identified as "Workbook_Activate" (below) be activated once a certain
action takes place (i.e. cursor moves based on an entry being made in a
specific column).

I have used code similar to the following, but is not functioning as
desired. Suggestions for a workable solution??

-------------------------------

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

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

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

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


--
itsthebike
------------------------------------------------------------------------
itsthebike's Profile: http://www.excelforum.com/member.php...o&userid=27425
View this thread: http://www.excelforum.com/showthread...hreadid=559549