| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Force sort before worksheet exit | Excel Worksheet Functions | |||
| when i exit excel worksheet shortcuts are put on my c-drive | Excel Discussion (Misc queries) | |||
| [Fwd: Run macro on exit worksheet/workbook] | Excel Discussion (Misc queries) | |||
| Run macro on exit worksheet/workbook | Excel Worksheet Functions | |||
| Saving Worksheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
