Pause Macro Execution without using "Stop"

[shawnvw]

I have macros that often pause for the user to take some action -- for instance, to confirm that the correct cells are selected, or to delete something. Usually I use the "Stop" command, which opens the VBA editor; when I finish doing the manual action, I just resume the macro.

When writing macros for actual users, I'd like to do the same thing without their having to deal with the VBA window. Is there a way to pause and resume action and remain in the Excel window?

(Also, does this solution work in Word VBA too?)

Thanks.

[mikerickson]

Are you looking for something like

Please Login or Register  to view this content.

[shawnvw]

No, not really. I want them to be able to resume execution at the point where it stopped.

[mikerickson]

While this code is pause, what do you want the user to do. I got the impression from the OP, that you only want a confirmation from the user "Should we continue"?

If you want the user to exit VB and edit sheets, that can't be done by "pausing" a macro. One would have to write two macros, one for before the editing and one for after.