Yes indeed, you have a helpful suggestion, thanks. In fact, it
occurred to Me that a similar set of steps might be incorporated into
other sequences in the program. After all, the situation of "already
selected" happens most often AFTER the user closes a user form or puts
things on "Pause" because of a phone call. It occurred to me that I
could include more than one level of "interruption" choices.
They already have the "Panic Button" which saves everything and
closes the program down entirely for a significant interruption. But
there are others which are not so drastic. Like, a supervisor might
get a personal call from hubby or wife or kid just to ask something
that would not require more than a few moments, but they still might
need to reduce the screen from view since the info is security level.
So, the "Pause" button could cover everything from view and then
re-up the userform at the same place as it was before the "Pause" in a
similar way as you said.
And, I like the whole idea of what you described for a "Panic
Button" save situation, anyway . . . because then the user CAN have
the choice to get back to where they were, and would not have to click
on another cell to get the userform to fire.
Thanks, and as I said to David, I'll post the code when I get it
working.