Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you make a userform open automatically when you open excel? | Excel Worksheet Functions | |||
Userform Commands - Switching Question | Excel Discussion (Misc queries) | |||
Unload/Hide Userform when switching to a new Wbk | Excel Programming | |||
Always open Excel file with Userform | Excel Programming | |||
Switching from InputBox to UserForm? | Excel Programming |