I would like to halt the execution of a complex macro at a specific
location in the code and then navigate around several worksheets
(maybe even look at some different workbooks) and after I'm done
inspecting I would like to resume the macro execution at the same
point where it was halted.

What is the recommended method for doing something like this?