_Application.ScreenUpdating Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

True if screen updating is turned on.

public:
 property bool ScreenUpdating { bool get(); void set(bool value); };

public bool ScreenUpdating { get; set; }

Public Property ScreenUpdating As Boolean

Property Value

Boolean

Remarks

Turn screen updating off to speed up your code. You won't be able to see what the code is doing, but it will run faster.

Remember to set the ScreenUpdating property back to True when your code ends.

Applies to