Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pausing and resuming a running macro
Is there a way to pause a running macro at a certain stage of its execution
and to then to resume it? Thanks for any help. TIA Brian |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pausing and resuming a running macro
The Wait method will pause
Important The Wait method suspends all Microsoft Excel activity and may prevent you from performing other operations on your computer while Wait is in effect. However, background processes such as printing and recalculation continue. To be able to exit a subroutine and return to it while keeping the variables from being reinitialized, make the subroutine Static. "brian" wrote: Is there a way to pause a running macro at a certain stage of its execution and to then to resume it? Thanks for any help. TIA Brian |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pausing and resuming a running macro
You could add a wait
Application.Wait Now + TimeValue("0:00:10") ' 10 secs -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "brian" wrote in message ... Is there a way to pause a running macro at a certain stage of its execution and to then to resume it? Thanks for any help. TIA Brian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA macro pausing | Excel Worksheet Functions | |||
Pausing a macro | Excel Discussion (Misc queries) | |||
Pausing Macro | New Users to Excel | |||
pausing a macro | Excel Programming | |||
Pausing a VBA macro | Excel Programming |