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

Turn off auto redraw while updating chart format
 

Hi Charles,

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.

Application.ScreenUpdating=False
'Your chart code
Application.ScreenUpdating=True

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com