Excel 2003
I have 2 WBs open, say WB 1 & WB 2.
WB 2 is visible or active, whilst WB1 is "hidden."
If I close WB 2, is there anything, anywhere for macro purposes
that is triggered by the appearance of WB 1.
The command "Private Sub Workbook_SheetActivate(ByVal Sh As Object)"
appears not to be triggered, presumably because the sheet is already
effectively active.
However, a "change" has undoubtedly occured in the prevailing conditions,
as a different window gets displayed.
The problem is, I can't find an associated trigger!!
Any ideas.
DonWB