View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Geoff[_8_] Geoff[_8_] is offline
external usenet poster
 
Posts: 13
Default Userform shadows

Tom,
You are so right.

As you replied, I had just established the form moved ok
when called from VBE. I was trying to figure out the
difference between calling from a macro and calling from
VBE. It was the of course the macro calling the form
which had screenupdating turned off.

Thanks for making the link.

Geoff


-----Original Message-----
You have turned off screen updating when this form is

being shown.

Application.ScreenUpdating = False

set it to true before showing the form.

--
Regards,
Tom Ogilvy


"Geoff" wrote in message
...
Hi,
I deploy five userforms in an MS 2002 wbook. When

using
four of them I can grab the title bar and move the form
around the screen to uncover hidden data except for

one.
When grabbed and moved this form leaves an image behind
which can obscure the whole screen if moved
sufficiently. Looking at their properties I cannot see
any obvious differences.
Does anyone have any ideas how I might prevent this.

Grateful for any help.

T.I.A.
Geoff



.