View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Modeless form keeps taking 'focus'

When you show a modeless userform it takes the focus but after you click to
Excel the form never takes it back on its own. I don't know that you can
avoid the initial taking focus if that's what you mean.

--
Jim
"Michelle" wrote in message
...
| I'm using a modeless form in Excel 2007, I want to be able to scroll
around
| Excel and occasionally select something from the form. But when I use the
| form, the form gets 'focus' and things (like the mouse-wheel) don't apply
to
| the application anymore.
|
| Is there a way to hand focus back to the application? Or is there a way so
| set the form so that it doesn't take this 'focus'?
|
| Thanks
|
| Michelle
|