Export (0) Print
Expand All
Expand Minimize

ScreenUpdating Property

Office 2003

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


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


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.


This example turns off screen updating.

Spreadsheet1.ScreenUpdating = False

See Also | Repaint Method

© 2015 Microsoft