View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Charles in Iraq Charles in Iraq is offline
external usenet poster
 
Posts: 13
Default Turn off auto redraw while updating chart format

Greetings:

My VBA script changes a lot of my chart properties in order
to reach my desired chart format.

I would like to stop Excel from automatically redrawing the
chart after each change to a format property and instead
wait until I have finished making ALL of my chart property
changes before redrawing the chart.

Is there any property I can set, such as the ManualUpdate
property on Pivot Tables, or some method I can call to sus-
pend auto redrawing until I have finished setting all of
my format properties?

Regards,

Charles