Pausing and resuming a running macro

  • Thread starter Thread starter brian
  • Start date Start date
B

brian

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
 
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.
 
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)
 
Back
Top