Thread
:
Suspend window while Excel VBA macro is executing
View Single Post
#
2
Posted to microsoft.public.excel.programming
R.VENKATARAMAN
external usenet poster
Posts: 74
Suspend window while Excel VBA macro is executing
typethis code beginning of the code statements
Application.ScreenUpdating = False
at the end of the statemnets before end sub type
Application.ScreenUpdating = true
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
R.VENKATARAMAN
View Public Profile
Find all posts by R.VENKATARAMAN