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.