View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Userform shadows...

You need to learn to program without selecting and activating. In most
cases these activities are not required. Look at most of the code in this
group for examples.

--
Regards,
Tom Ogilvy


"RJH" wrote in message
...
Thanks to both!
I shut down screen updating to hide the "screen bounce" during the macro's
execution.

RJH


"Jim Cone" wrote in message
...
You need to turn on ScreenUpdating before showing the form.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"RJH" wrote in message
I have a sheet (Excel 2003, XP Home) that uses several user forms.
The user forms appear at the start of the macro and as each one

disappears
for the next a shadow is left.
Also if I drag the forms they leave a 'tail' of forms behind. The

shadows
and tails disappear if OK or CANCEL
are clicked but why does this happen?
Thanks!
RJH