PC Review


Reply
Thread Tools Rate Thread

Always on top and Deactivate event

 
 
Sjaakve
Guest
Posts: n/a
 
      11th Aug 2010
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deactivate event not firing vwood Webmaster / Programming 1 4th May 2010 01:03 AM
Make Worksheet Deactivate Event only run once robzrob Microsoft Excel Programming 2 13th Mar 2010 11:59 PM
WorkBook Deactivate Event faffo1980 Microsoft Excel Programming 2 7th Oct 2009 10:35 AM
Workbook Deactivate Event TerryF Microsoft Excel Programming 1 6th Jan 2004 01:16 AM
Deactivate Event - UnauthroizedAccessException Jon Credit Microsoft Dot NET Compact Framework 1 8th Aug 2003 11:56 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:36 AM.