Export (0) Print
Expand All
S
Expand Minimize

ScreenUpdating Property

Office 2003

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
		


See Also | Repaint Method


Show:
© 2015 Microsoft