Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fixing UserForm Position
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fixing the header on the top | Excel Discussion (Misc queries) | |||
UserForm position | Excel Discussion (Misc queries) | |||
Userform Position | Excel Programming | |||
Lock userform position | Excel Programming | |||
UserForm position | Excel Programming |