View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Pause, print preview, resume macro

There is no effective method to pause a macro. Once you light the fuse either
it executes or it doesn't. By using event programming however I have never
had the need to pause a macro. Perhaps with a better description of what you
want to accomplish we can help you work around your problem...
--
HTH...

Jim Thomlinson


"ToddEZ" wrote:

Does anyone know of to "pause" a macro to allow a user to print preview a
document and make any formatting changes, then resume the macro (without
having to call a new macro). I like the idea of using a msgbox, but users
cannot make changes while a msg box is displayed.

Thanks for your thoughts.