View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob Rob is offline
external usenet poster
 
Posts: 718
Default Userform on top z-order?

Hi, I just have a quick question for you experts:

I'm designing an excel sheet for which users would be able to use a userform
to enter data. Now, having it enter data is easy, but I'm having a problem
bringing the userform to the top of all other windows.

At my work, we have what's called an "L-bar" around the edge of our screen,
which stays at the top of all our other windows, and limits the window space
we can use. I would like the userform to be able to be placed on top of this
"L-bar", in the top most z-order, so it won't take up any more of the very
little window space we have already. I tried making the userform modeless,
but it doesnt really help when excel itself cannot even go on top of this
"L-bar"!

Is there any way that I could make the userform (or any other data entry
form) have the highest z-order in the system?


Thank you,

-Robert G.