Excel 2007: unusual flicker with Application.ScreenUpdating = True
try
application.screenupdating = false
at the beginning of your code
and
application.screenupdating = true
at the end
--
Gary Keramidas
Excel 2003
"Paul Martin" wrote in message
...
I have an XL03 application that has been converted to XL07. I have a
routine that updates a chart by dynamically changing the data source
and labels according to a user's dropdown selection. I turn off
ScreenUpdating and when finished turn it back on again. There is an
unusual amount of screen flicker, which I have identified as occuring
only after I turn on ScreenUpdating. This seems weird and I'm
wondering if others have experienced it and whether there's a fix/
workaround.
Thanks in advance
Paul Martin
Melbourne, Australia
|