Exit a worksheet with out saving changes
 

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

Exit a worksheet with out saving changes
 

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

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