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:
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
Only, the ws.Activate piece doesn't trigger the Worksheet_Activate event. Any suggestions?