Userform is moveable and leaves traces of prior positions Excel 2000

[L Mehl]

Hello.

I am new to user forms in Excel.

The form causing the problem is not meant to be moved, but I don't know to
freeze its position, using form properties, or VBA.

When I drag the form around the screen, partial images from its prior
positions remain on the screen. Such images do not occur in Windows when I
drag windows around.

I have heard of a document describing an "unmovable userform" that I can't
find on the web.

Can someone tell me how to:
1 - freeze the form's position on the screen, or
2 - change settings to eliminate the phantom traces.

Thanks for any help.

Larry Mehl

 

[Dave Peterson]

I'm guessing that screenupdating is turned off when you show the form.

Try turning it back on, show the form, and then turn it back off (if you want).

 

[L Mehl]

Dave --

Thanks.

Larry

I'm guessing that screenupdating is turned off when you show the form.

Try turning it back on, show the form, and then turn it back off (if you want).