Fixing UserForm Position

M

Marston

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?
 
J

Jim Cone

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userform Textbox to Worksheet Textbox 1
Hiding a "Userform" instead of closing it??? 3
userform dragging problem 1
How to bottom-align a control on a UserForm? 2
Lock Position of Controls on a UserForm 4
Save Form Position on Close 4
Allow text in locked cells on a worksheet from a userform 16
Lock userform position 3

Top