View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default 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.