Hi all,
Is it possible to fire Worksheet_Activate event from another workbook? Let's say I have workbook "WB_1" that references sheets in "WB_2" through VBA. On Sheet1 in WB_2 there's some code that gets triggered when the sheet is activated. So, in a perfect world I would want to be able to run the following code in WB_1:
Code
Sub Test()
For Each ws In Workbooks("WB_2.xlsx").Worksheets
ws.Activate
'This would make the code jump to WB_2, Sheet1 and run Worksheet_Activate event
'More code that will be placed in WB_1 and will affect sheets in WB_2
Next ws
End Sub
Display More
Only, the ws.Activate piece doesn't trigger the Worksheet_Activate event. Any suggestions?