Thread: Chart rotation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Paul Robinson Paul Robinson is offline
external usenet poster
 
Posts: 208
Default Chart rotation

Hi
Have you tried putting in this line at the top of the code
Application.Screenupdating = False

You might also scatter in a few lines of
DoEvents

Excel 2007 in particular can be terrible at updating graphics & I find
I have to drop DoEvents inside loops to make things "go" properly.
regards
Paul

On Apr 1, 7:40*am, Fan924 wrote:
When I grab the corner of a 3D chart and rotate it, the chart tuns
white. It returns to normal when done. Can this white background be
eliminated? * I have a button and macro that makes it rotate and that
white makes a terrible flicker.