Excel 2007: unusual flicker with Application.ScreenUpdating = True
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
|