View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
George J George J is offline
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