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