LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default Userform to be always on top of all Applications?

Not sure if this is possible, especially as i am using
Excel97. But what i want is my userform to be the top
window (always visible/active) even if other applications
are open.

eg user is using the userform then decides to open windows
explorer - userform stays on top so the user has to close
down the userform before they can go on to do something
else.

I know alot of you will shrink back from the thought of
doing this to a user, but i think it will save alot of
problems for me later on.

I can't use hwnd so tried hWnd = FindWindow
("ThunderXFrame", Me.Caption) with dim hwnd as long
and can do a little more, but do not really have a clue
how to go about making a dominant userform.

I have some code taken from various sources, but am
creating a real mess. If anyone can assist i would be
grateful.

George
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
"Ignore other applications" Geoff Excel Discussion (Misc queries) 1 March 14th 05 12:27 PM
Linking to other applications rams Excel Programming 2 September 3rd 04 05:13 PM
SWITCH BETWEEN APPLICATIONS Riana de Lange Excel Programming 0 November 20th 03 07:55 PM
Other applications Patrick Molloy[_4_] Excel Programming 2 July 23rd 03 12:08 AM


All times are GMT +1. The time now is 05:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"