Macro to set a spreadsheet restore point?

[BBrandt]

I'm working with a spreadsheet that contains a large number of user inputs that are all either blank or set at a default starting value when the spreadsheet is opened. When the user is done inputting data, they click a button and a macro generates a table's worth of results/outputs for them. After this has happened, I would like there to be a button that gives the user the option to restore the spreadsheet to its original form with, sort of like setting the initial condition of the spreadsheet as a restore point. Is this possible? If so, what would be the best way of accomplishing this? Thanks in advance!

 

[VoG]

I would

- get your macro to copy the original sheet (maybe as a hidden sheet)

- get the Restore button to delete the altered sheet, unhide the hidden copy and rename with the name of the original sheet.

 

[BBrandt]

The trouble with that is that there are a ton of specifically labeled cells which need to retain their labels in order for other parts of the workbook and some of the macros to function properly. Since copying like that would not keep these labels, I don't think would quite work.

 

[VoG]

Here's an example of an Undo macro http://www.j-walk.com/ss/excel/tips/tip23.htm