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.
--
itsthebike
------------------------------------------------------------------------
itsthebike's Profile:
http://www.excelforum.com/member.php...o&userid=27425
View this thread:
http://www.excelforum.com/showthread...hreadid=559201