ScreenUpdating Property

True if screen updating is turned on. The default value is True. Read/write Boolean.

expression.ScreenUpdating

*expression   * Required. An expression that returns one of the objects in the Applies To list.

Remarks

Setting this property to False causes the chart workspace or spreadsheet to stop redrawing. To prevent screen flicker or to prevent the user from seeing individual updates, set this property to False, perform your update operations, and then reset this property to True. After setting the ScreenUpdating property to False, the chart workspace or spreadsheet will still redraw if the user refreshes the page, and if the Repaint method is called on the control.

Example

This example turns off screen updating.

Spreadsheet1.ScreenUpdating = False

Applies to | ChartSpace Object | Spreadsheet Object

See Also | Repaint Method