Suspend window while Excel VBA macro is executing

[Guest]

How do I suspend the application window from showing progress while an Excel
VBA macro is executing? Tha macro involves a lot of jumping between
worksheets, and I suspect that the updating of windows takes a lot of time.

 

[R.VENKATARAMAN]

typethis code beginning of the code statements

Application.ScreenUpdating = False

at the end of the statemnets before end sub type

Application.ScreenUpdating = true

How do I suspend the application window from showing progress while an Excel
VBA macro is executing? Tha macro involves a lot of jumping between
worksheets, and I suspect that the updating of windows takes a lot of

time.

 

[Nikos Yannacopoulos]

Knut,

Put this at the beginning of your code:

Application.ScreenUpdating = False


and then this at the end:

Application.ScreenUpdating = True

HTH,
Nikos

How do I suspend the application window from showing progress while an Excel
VBA macro is executing? Tha macro involves a lot of jumping between
worksheets, and I suspect that the updating of windows takes a lot of

time.

 

[Guest]

Thanks. It helped a lot!
Knut

Knut,

Put this at the beginning of your code:

Application.ScreenUpdating = False


and then this at the end:

Application.ScreenUpdating = True

HTH,
Nikos


time.

 

[Guest]

Thanks. It helped a lot!!
Knut

typethis code beginning of the code statements

Application.ScreenUpdating = False

at the end of the statemnets before end sub type

Application.ScreenUpdating = true





time.