It sounds to me that you are going about this the wrong way, though this
is just an opinion based on the note I see here. Rather than thinking of
pausing code, you may want to think outside the box. Have your code  end
instead of pause.



For example, have a "User Form" appear. Via the user form have users
enter changes required to the spreadsheet. This can be done within the
form when, upon hitting a button on the user form changes will take
effect, and the program may be restarted.