Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Alex Meyer   on Dec 18 In MS Office Category.

  
Question Answered By: Allison Stanley   on Dec 18

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.

Share: 

 

This Question has 6 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on possible to change Protected Sheet error message? Or get search suggestion and latest updates.


Tagged: