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
= = = = = = = = = = = = = = = =
Bookmarks