Turn off auto redraw while updating chart format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
Click to expand...

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
 
Back
Top