I am not using a button. I am using a pull-down custom menu option. And the
function is public.

Basically the work-around would be if I knew how to load a form but not make
it Modal (linger on the screen and stop code execution) if I just issue the
command
UserForm2.Show
Is this possible? Then I would just have the menu call the sub and the sub
would load the form and continue on. This form is a progress bar and I want
to continually update it during the execution of the rest of the code in the
sub.