I assumed you were just looking at your code and seeing what it does to
data, and then resuming your code.

You need to do what Dave mention first off. On vbyes then endsub, then
somehow have another button to resume, or however you want to trigger
the after checking sub, maybe a checkbox that appears on your sheet if
the user selects yes, and after they tick the box it fires off the
second sub.

What if the person selects no, well then the checkbox on the sheet
remains hidden and the second sub is run straight away.

Stopher