View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default 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