ScreenUpdating Property

Microsoft Office Web Components Object Model

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.

Example

This example turns off screen updating.

Spreadsheet1.ScreenUpdating = False