AFAIK, "end" ends everything, including user forms. So the form is probably
loading, and then getting "ended".

You don't want to "end" until you are really finished (i.e. about to close
the workbook). In fact, you shouldn't even want to do it then. Only use
"end" as an "emergency shutdown" if there is a fatal error, and processing
must not continue.

Just return from whatever subroutines you are in (using Exit Sub if you
can't just return normally). The form will then be left showing and VBA
will be waiting for the next user event.

BTW I don't know what you're expecting to do with a form called pauseform,
but I suspect you won't achieve it. Excel programs are event-driven and
there is no concept such as a "pause".