switching out of Excel with userform open
 

I have a userform that remains open as a tool to the user and gives them the
choice of leaving the focus on it or the active workbook. If the form
happens to have the focus when I Alt-Tab to another application (e.g.
Outlook), alt-tabbing back shows me the userform but not Excel, that is, the
userform floats on its own above Outlook and I can't see Excel.

Any ideas how to deal with this? It can be resolved by clicking a couple of
times on the Excel icon in the taskbar but I like Alt-Tab and I know other
people who'll be using this are the same!

I guess an approach would be to find an Excel-loses-focus event and use this
to run AppActivate Application.Caption or some such to move the focus back to
Excel just before switching to the other application but I haven't found this.

switching out of Excel with userform open
 

Use the SetWindowLong API as explained he

http://www.cpearson.com/excel/SetParent.htm

RBS


"Smallweed" wrote in message
...
I have a userform that remains open as a tool to the user and gives them
the
choice of leaving the focus on it or the active workbook. If the form
happens to have the focus when I Alt-Tab to another application (e.g.
Outlook), alt-tabbing back shows me the userform but not Excel, that is,
the
userform floats on its own above Outlook and I can't see Excel.

Any ideas how to deal with this? It can be resolved by clicking a couple
of
times on the Excel icon in the taskbar but I like Alt-Tab and I know other
people who'll be using this are the same!

I guess an approach would be to find an Excel-loses-focus event and use
this
to run AppActivate Application.Caption or some such to move the focus back
to
Excel just before switching to the other application but I haven't found
this.

switching out of Excel with userform open
 

Thanks for that - interesting code! I seem to get a problem with it that
Excel now completely vanishes off the Alt-Tab list.

"RB Smissaert" wrote:

Use the SetWindowLong API as explained he

http://www.cpearson.com/excel/SetParent.htm

RBS


"Smallweed" wrote in message
...
I have a userform that remains open as a tool to the user and gives them
the
choice of leaving the focus on it or the active workbook. If the form
happens to have the focus when I Alt-Tab to another application (e.g.
Outlook), alt-tabbing back shows me the userform but not Excel, that is,
the
userform floats on its own above Outlook and I can't see Excel.

Any ideas how to deal with this? It can be resolved by clicking a couple
of
times on the Excel icon in the taskbar but I like Alt-Tab and I know other
people who'll be using this are the same!

I guess an approach would be to find an Excel-loses-focus event and use
this
to run AppActivate Application.Caption or some such to move the focus back
to
Excel just before switching to the other application but I haven't found
this.

switching out of Excel with userform open
 

You probably coded something wrong.
Post your code and we will see.

RBS

"Smallweed" wrote in message
...
Thanks for that - interesting code! I seem to get a problem with it that
Excel now completely vanishes off the Alt-Tab list.

"RB Smissaert" wrote:

Use the SetWindowLong API as explained he

http://www.cpearson.com/excel/SetParent.htm

RBS


"Smallweed" wrote in message
...
I have a userform that remains open as a tool to the user and gives them
the
choice of leaving the focus on it or the active workbook. If the form
happens to have the focus when I Alt-Tab to another application (e.g.
Outlook), alt-tabbing back shows me the userform but not Excel, that
is,
the
userform floats on its own above Outlook and I can't see Excel.

Any ideas how to deal with this? It can be resolved by clicking a
couple
of
times on the Excel icon in the taskbar but I like Alt-Tab and I know
other
people who'll be using this are the same!

I guess an approach would be to find an Excel-loses-focus event and use
this
to run AppActivate Application.Caption or some such to move the focus
back
to
Excel just before switching to the other application but I haven't
found
this.