| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Suspend window while Excel VBA macro is executing
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Suspend window while Excel VBA macro is executing
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Suspend window while Excel VBA macro is executing
Thanks. It helped a lot!!
Knut "R.VENKATARAMAN" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| executing a macro within another | Excel Discussion (Misc queries) | |||
| What macro is executing? | Excel Programming | |||
| Executing an older excel 4.0 macro | Excel Programming | |||
| Excel VBA - Executing external programs in an excel macro | Excel Programming | |||
| Suspend/resume running of a macro | Excel Programming | |||
Linear Mode
