screen flicker

[mark kubicki]

(while some code is executing) i've got some random "screen flickering"
happening...

obviously, (i assume) there is a screen updating happening that i have not
turned off; ...can't seem to find it...

is there a way to stop the program or otherwise mark when this event
happens, so that i may then determine how to appropriatly deal with it?

mark

 

[Fredrik Wahlgren]

(while some code is executing) i've got some random "screen flickering"
happening...

obviously, (i assume) there is a screen updating happening that i have not
turned off; ...can't seem to find it...

is there a way to stop the program or otherwise mark when this event
happens, so that i may then determine how to appropriatly deal with it?

mark

Use Application.ScreenUpdating = False in your macro

/Fredrik

 

[Martin Wheeler]

Hi Mark
I use Application.ScreenUpdating = False at the beginning of each sub and
Application.ScreenUpdating = True at the end. This stops most flicker. If
you app is reasonably small you could try using Application.ScreenUpdating =
False in the first sub and Application.ScreenUpdating = True at the end of
the last sub. I think this will stop all flicker. I do not use this as my
app has many exit points and goes in many directions.
Good luck
Ta,
Martin