Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Always on top and Deactivate event
Hi,
I've created a worksheet that displays a userform. The excel window is located somewhere of the screen and the userform is displayed in the top os the screen. The userform acts as some kind of switchboard allowing users to quikly select and open various applications. A code was added to ensure the userform stays on top always. A button on the userform slides the form halfway of the screen after which te same button can be clicked to let te form slide back into the screen. Now this al works perfectly. But... I would like the userform to move to the position halfway outside the screen when I select another window, my browser for instance. I cannot get excel to notice when i select the other window. I've tried various combination of application and workbook with the deactivate and windowdeactivate events. I think this has something to do with the always on top function. Is it possible to work around this. For instance by checking the locations of a mouse-click against the location of the userform. Any other suggestion are also welcome. Thanks in advance. Sjaak |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make Worksheet Deactivate Event only run once | Excel Programming | |||
WorkBook Deactivate Event | Excel Programming | |||
Changing sheets after the DeActivate Event. | Excel Discussion (Misc queries) | |||
Workbook Deactivate event problem | Excel Programming | |||
Workbook Deactivate Event | Excel Programming |