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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
Stop Command Question 4
Pause, print preview, resume macro 4
Funcitonality to pause macro?! 13
Pause macro user selection, then resume 2
Stop / Pause a Macro using Pause button 4
pause 4
Pause a macro for user input 15

Back
Top