Thread
:
Suspend window while Excel VBA macro is executing
View Single Post
#
4
Posted to microsoft.public.excel.programming
Knut S
external usenet poster
Posts: 3
Suspend window while Excel VBA macro is executing
Thanks. It helped a lot!
Knut
"Nikos Yannacopoulos" wrote:
Knut,
Put this at the beginning of your code:
Application.ScreenUpdating = False
and then this at the end:
Application.ScreenUpdating = True
HTH,
Nikos
"Knut S" <Knut
wrote in message
...
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.
Reply With Quote
Knut S
View Public Profile
Find all posts by Knut S