Stop and Restart

[Guest]

When executing a macro, I want to activate a workbook, suspend the macro
while I make changes in the workbook, then close the workbook and resume
executing the macro.

Is there some standard way to do this?

 

[Earl Kiosterud]

Bill,

You can't interact with the workbook while the macro is running. It needs
to end for the user to be able to perform actions on the workbook, then
another (or the same) macro be run later, after the user has done his
actions on the workbook.