View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Martin[_2_] Paul Martin[_2_] is offline
external usenet poster
 
Posts: 133
Default 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