Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I turn on auto size to an organization chart? | Charts and Charting in Excel | |||
How do you turn off pivot table auto format in Excel? | Excel Discussion (Misc queries) | |||
auto format - how do I turn it off? | Setting up and Configuration of Excel | |||
How can you turn off screen Redraw | Excel Programming | |||
How can you turn off screen Redraw | Excel Programming |