Macro command SetScreenUpdating

<< Click to Display Table of Contents >>

Navigation:  Macros > Macro commands and parameters > Macro reporting commands > Macro write to Excel >

Macro command SetScreenUpdating

Purpose:

Do not show edits of the workbook on screen (saves time).

 

General notation:

SetScreenUpdating ( Update )

 

Update is a boolean.

 

Example:

 

SetScreenUpdating ( FALSE )