Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pause a macro | Excel Discussion (Misc queries) | |||
CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
Pause Macro 2 | Excel Discussion (Misc queries) | |||
code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
Macros Pause | Excel Discussion (Misc queries) |