Exit a worksheet with out saving changes

[Sherry]

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

 

[JLatham]

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]

Good idea. Thank you!

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.

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