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.

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.

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.

Using ctrl-f6 and the window menu indicate that Antoun is using
tools|Options|View tab|Windows in taskbar.

Unchecking that option would fix the problem--since alt-tab wouldn't stop on
other workbooks open in the same instance. I'm guessing that Antoun won't want
to do that.

Tim Williams wrote:

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.

--

Dave Peterson

Tim Williams wrote:
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

A single instance.

Dave Peterson wrote:
Using ctrl-f6 and the window menu indicate that Antoun is using
tools|Options|View tab|Windows in taskbar.

Unchecking that option would fix the problem--since alt-tab wouldn't stop on
other workbooks open in the same instance. I'm guessing that Antoun won't want
to do that.

Why not ? I'm desperately looking for any means to prevent my users from
crashing my pretty user interface (which works very well as long as
there is no user putting his dirty fingers on it ;-)).


It seems interesting... I'll test it today.

Just tested:
With Tools|Options|View tab|Windows in taskbar Checked:
XL2000:
Alt+Tab: WB_Activate event does not fire
Cntl+F6: WB_Activate event does fire

XL2002:
Alt+Tab: WB_Activate event does fire
Cntl+F6: WB_Activate event does fire

With Tools|Options|View tab|Windows in taskbar UnChecked:
XL2000 + XL2002:
Alt+Tab: Not applicable
Cntl+F6: WB_Activate event does fire

NickHK

"Dave Peterson" wrote in message
...
Using ctrl-f6 and the window menu indicate that Antoun is using
tools|Options|View tab|Windows in taskbar.

Unchecking that option would fix the problem--since alt-tab wouldn't stop
on
other workbooks open in the same instance. I'm guessing that Antoun won't
want
to do that.

Tim Williams wrote:

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.

--

Dave Peterson

Just tested:
With Tools|Options|View tab|Windows in taskbar Checked:
XL2000:
Alt+Tab: WB_Activate event does not fire


Oddly enough it does for me. Excel 2000 (9.0.6926 SP-3).


--
Jim
"NickHK" wrote in message ...
| Just tested:
| With Tools|Options|View tab|Windows in taskbar Checked:
| XL2000:
| Alt+Tab: WB_Activate event does not fire
| Cntl+F6: WB_Activate event does fire
|
| XL2002:
| Alt+Tab: WB_Activate event does fire
| Cntl+F6: WB_Activate event does fire
|
| With Tools|Options|View tab|Windows in taskbar UnChecked:
| XL2000 + XL2002:
| Alt+Tab: Not applicable
| Cntl+F6: WB_Activate event does fire
|
| NickHK

I just figured that you wouldn't want to make a change to the user's
environment--especially one that they could change back as soon as they noticed
it.

But maybe you want to take that chance.

Antoun wrote:

Dave Peterson wrote:
Using ctrl-f6 and the window menu indicate that Antoun is using
tools|Options|View tab|Windows in taskbar.

Unchecking that option would fix the problem--since alt-tab wouldn't stop on
other workbooks open in the same instance. I'm guessing that Antoun won't want
to do that.

Why not ? I'm desperately looking for any means to prevent my users from
crashing my pretty user interface (which works very well as long as
there is no user putting his dirty fingers on it ;-)).

It seems interesting... I'll test it today.

--

Dave Peterson

HTML???

What the heck happened?

<vbg

Jim Rech wrote:

Just tested:
With Tools|Options|View tab|Windows in taskbar Checked:
XL2000:
Alt+Tab: WB_Activate event does not fire


Oddly enough it does for me. Excel 2000 (9.0.6926 SP-3).


--
Jim
"NickHK" wrote in message
...
| Just tested:
| With Tools|Options|View tab|Windows in taskbar Checked:
| XL2000:
| Alt+Tab: WB_Activate event does not fire
| Cntl+F6: WB_Activate event does fire
|
| XL2002:
| Alt+Tab: WB_Activate event does fire
| Cntl+F6: WB_Activate event does fire
|
| With Tools|Options|View tab|Windows in taskbar UnChecked:
| XL2000 + XL2002:
| Alt+Tab: Not applicable
| Cntl+F6: WB_Activate event does fire
|
| NickHK

--

Dave Peterson

Won't happen again!<g

--
Jim
"Dave Peterson" wrote in message
...
| HTML???
|
| What the heck happened?
|
| <vbg
|
| Jim Rech wrote:
|
| Just tested:
| With Tools|Options|View tab|Windows in taskbar Checked:
| XL2000:
| Alt+Tab: WB_Activate event does not fire
|
|
| Oddly enough it does for me. Excel 2000 (9.0.6926 SP-3).
|
|
| --
| Jim
| "NickHK" wrote in message
| ...
| | Just tested:
| | With Tools|Options|View tab|Windows in taskbar Checked:
| | XL2000:
| | Alt+Tab: WB_Activate event does not fire
| | Cntl+F6: WB_Activate event does fire
| |
| | XL2002:
| | Alt+Tab: WB_Activate event does fire
| | Cntl+F6: WB_Activate event does fire
| |
| | With Tools|Options|View tab|Windows in taskbar UnChecked:
| | XL2000 + XL2002:
| | Alt+Tab: Not applicable
| | Cntl+F6: WB_Activate event does fire
| |
| | NickHK
|
| --
|
| Dave Peterson

"Dave Peterson" a écrit dans le message news:
...
I just figured that you wouldn't want to make a change to the user's
environment--especially one that they could change back as soon as they
noticed
it.

But maybe you want to take that chance.

Actually, I was pondering trapping their keyboard to send an electric shock
on Alt + Tab combo... so an Excel option I can uncheck and re-check it quite
a mild change to their environment ;-)

Officially, I can tell'em they'll lose guarantee if they touch this option.

Thanks a lot for this most welcome suggestion !

Thanks for answering my question about how to get alt tab to show/switch
between open workbooks as well as alert me to ctrl f6!


*** Sent via Developersdex http://www.developersdex.com ***