Application.ScreenUpdating = False and it still flicker !
Hi Gunner,
I think it is normal sometimes to expect a flicker when screenupdating
is set to true, even if it was previously "true". Depending on what's on
the screen when done this may not be noticeable, but try this:
Draw a large rectangle with a diagonal two colour fill effect. Then run
the single line:
Application.screenupdating = True
If you are running the same Sub many times in your overall code, you
could well see the screen flicker each time. So ensure screenupdating is
only reset once in an entire run of code. Say, False just before
anything that's going to change what's on the screen and True when there
will be no more changes. Might require moving the screenupdating code to
different Sub('s).
Regards,
Sandy
Gunnar Johansson wrote:
Hi,
I try once again since I didn't get a usable respons last time.
I have "Application.ScreenUpdating = False" in first row after "Sub.." and
has
it as "= True" the last line just before "End Sub"
I belive many of you find this flickering but for some, often smaller
macros, there is NO flickering. The question is - WHYdoes it occure when
screenupdating=false? Is it just some special commands, is it the length of
the code, is it the screenupdating=false command itself??? ... or?
If some of you know if there is some special commands that create screen
flicker despite screenupdating=false, please tell so I can try to avoid it
and use other
solutions instead.
/Regards
|