View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Knut S Knut S is offline
external usenet poster
 
Posts: 3
Default 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.