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

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

Excel 2007: unusual flicker with Application.ScreenUpdating =True
 

Gary, if you read my post, you'll see that I've done exactly that.
When I turn ScreenUpdating back on, I get flicker as if it had never
been off. And, interestingly, even if I don't turn it back on, it
goes on automatically after the procedure has completed. Obviously,
XL07's change in architecture has affected ScreenUpdating in ways not
intended and I'm wondering what other's experiences have been and how
they've dealt with them.