LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Userform shadows

The cause is that you have ScreenUpdating set to false when the forms are
being displayed.

--
Regards,
Tom Ogilvy


"Geoff" wrote in message
...
Pete,
No, I call them from screen command buttons linked to a
macro, at that stage there is no other code running.

What I have found since is a bit different to my original
statement- at first only the one form (second in the
list) seemed to be affected. Now it is every form
excepting the first, this never leaves a trailing image.

Intriguingly, with a bit of experimentation, I have found
the forms causing the problem do not leave a trailing
image if they are run from the VBE. When called from the
screen they always do.

Any further ideas?

Geoff
-----Original Message-----
Geoff,

I find this often happens with dialogue boxes, etc when
there's a lot of processing going on in the background,
e.g. Find and replace over multiple sheets.

Do you have any code associated with this form which

could
be running while you're trying to move it?

Pete.

-----Original 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
.

.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shadows and printing Jeppe Excel Discussion (Misc queries) 0 August 8th 07 02:32 PM
Shadows don't work right in Office 2007? Jaimie Excel Discussion (Misc queries) 1 May 1st 07 10:53 PM
Shadows of the Pivottable Field List while macro is running David P Excel Worksheet Functions 0 February 25th 05 07:11 PM
UserForm Gabriel[_2_] Excel Programming 0 July 28th 03 04:40 PM
Userform help Lorenzo Excel Programming 1 July 25th 03 01:05 PM


All times are GMT +1. The time now is 08:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"