Workbook_Activate not triggered by Alt+Tab
Antoun,
Just to clarify - are you talking about a single instance of Excel, or multiple instances? Your use of alt+Tab suggests multiple
instances.
Tim
--
Tim Williams
Palo Alto, CA
"Antoun" wrote in message ...
Jim Rech wrote:
The behavior Dave described for Excel 2003 is the same in 2000. Within a
single instance of Excel you have to use the Workbook_Activate event to trap
arriving at a worksheet from another workbook.
I can guarantee you it doesn't fire when using Alt+Tab (at least with XL
2000 / Win 2000). It works normally when using Ctrl+F6, the task bar,
the Window menu, etc.
|