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