View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
R.VENKATARAMAN R.VENKATARAMAN is offline
external usenet poster
 
Posts: 74
Default 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.