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