Exit a worksheet with out saving changes
Good idea. Thank you!
"JLatham" wrote:
Yes, it's possible. It takes some planning and thought to get to work
properly.
The easiest way to do it would be to have code make a hidden copy of the
worksheet as it is when you first go to it from the Userform. Then if the
user hits the [cancel] button, the contents of the hidden sheet would simply
be copied from it back into the sheet that had been edited, but which needs
to be un-edited.
"Sherry" wrote:
I have a Userform where the user selects a worksheet to "Edit". The
worksheet becomes visible and has a Save and Cancel button on it. I want the
user to be able to make edits and then Cancel out, taking him back to the
Original UserForm ignoring all changes. Is this possible?
Sherry
|