Hello,

I'm using VBA with Excel 2000 (9.0.3821 SR-1) on Windows 2000 (5.0 2195
SP4). The events Workbook_Activate, Sheet_Activate and
WorkbookWindow_Activate are not triggered when arriving on my Workbook by
Alt+Tab.

Has someone ever encountered this problem ? Is there any solution (service
pack, any means of detecting or forbidding Alt+Tab) ?

Thanks in advance for any hint !

Antoun

These events fire when you're moving from one location in that excel instance to
another--not when you're swapping between applications.

I think most don't see this as a problem.

Antoun wrote:

Hello,

I'm using VBA with Excel 2000 (9.0.3821 SR-1) on Windows 2000 (5.0 2195
SP4). The events Workbook_Activate, Sheet_Activate and
WorkbookWindow_Activate are not triggered when arriving on my Workbook by
Alt+Tab.

Has someone ever encountered this problem ? Is there any solution (service
pack, any means of detecting or forbidding Alt+Tab) ?

Thanks in advance for any hint !

Antoun

--

Dave Peterson

"Dave Peterson" a écrit dans le message news:
...
These events fire when you're moving from one location in that excel
instance to
another--not when you're swapping between applications.

they do fire when I swap from one Excel file to another... except if I do it
with Alt+Tab.

I think most don't see this as a problem.

I would not if it was between applications. But between Excel files it's a
big problem for me.

The workbook_activate events fired for me when I used alt-tab--if those
workbooks were in the same instance of excel.

The sheet_activate events fire when I change sheets in the same workbook--not
swap workbooks.

I used xl2003 and windowsXP home.



Antoun wrote:

"Dave Peterson" a écrit dans le message news:
...
These events fire when you're moving from one location in that excel
instance to
another--not when you're swapping between applications.

they do fire when I swap from one Excel file to another... except if I do it
with Alt+Tab.

I think most don't see this as a problem.

I would not if it was between applications. But between Excel files it's a
big problem for me.

--

Dave Peterson

Dave Peterson wrote:
The workbook_activate events fired for me when I used alt-tab--if those
workbooks were in the same instance of excel.
(...)
I used xl2003 and windowsXP home.

I'm quite happy for you... alas, my customer uses XL 2000 and Windows 2000.

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. And Worksheet_Activate to
trap arriving at a worksheet from another worksheet in the same workbook.

From another application or another instance of Excel, no Excel event fires.
I remember wishing for that once upon a time, maybe to clear the clipboard
but I'm not sure.

--
Jim
"Antoun" wrote in message
...
| Dave Peterson wrote:
| The workbook_activate events fired for me when I used alt-tab--if those
| workbooks were in the same instance of excel.
| (...)
| I used xl2003 and windowsXP home.
|
| I'm quite happy for you... alas, my customer uses XL 2000 and Windows
2000.