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