View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Fixing UserForm Position

Marston,
I believe the best / easiest way is to turn on ScreenUpdating
before showing the form. Turn it back off after hiding the form.
Regards,
Jim Cone
San Francisco, CA

"Marston" wrote in message m...
In my code, I'm often turning screen updating on and off.
I've noticed that when its off, if a userform is up and the user drags it,
it creates ghosts. Is there a way to lock down a userform's position
so it can't be moved?