Pause a VBA Module
 

I'm trying to insert a pause in a module that will allow me to work on the
worksheet before pressing OK to resume the module. Can get the pause to
work, but can't get working on the worksheet to work. Any help would be
appreciated.

TIA

Rick

Pause a VBA Module
 

Rick,

Try using the application.ontime event to fire a new macro (or the
continuation) of the routine.

HTH.

Paul M.
"Rick Campbell" wrote in message
hlink.net...
I'm trying to insert a pause in a module that will allow me to work on the
worksheet before pressing OK to resume the module. Can get the pause to
work, but can't get working on the worksheet to work. Any help would be
appreciated.

TIA

Rick

Pause a VBA Module
 

Rick -

My approach is often to build two macros. At the end of the first, I
have it put a command bar button or worksheet button that says Click
Here When Ready. This button runs the second macro.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Rick Campbell wrote:
I'm trying to insert a pause in a module that will allow me to work on the
worksheet before pressing OK to resume the module. Can get the pause to
work, but can't get working on the worksheet to work. Any help would be
appreciated.

TIA

Rick