Reset spreadsheet to its original state upon opening (not revert to blank cells)

[Madraykin]

Hi all

Does anyone know if there is a way to have a button to 'reset' a spreadsheet to the values it has upon opening?

For background the spreadsheet will have a number of graphs present that are pre-populated. Sliders etc will be used to change values and visualise how these will change the graphs, but I want to be able to revert back to that original pre-populated state

There will be a lot of background data and formulae within the workbook that I want to preserve

Any ideas?

All help appreciated, as always

Mads

 

[Yongle]

Yes
- open the workbook and immediately save a copy of the file with name it "Playing 181122" (unique to 22 Nov 2018)
- now you can do whatever you want to Playing 181122
- next day open the original file and immediately save it with unique name for the day "Playing 181123"

etc

Could be automated using VBA

 

[Madraykin]

Thanks Yongle

Would this be functional if someone wanted to 'reset' the spreadsheet to original values halfway through using it for example?

ie. this spreadsheet will be being used during a presentation to visualise different options, and I want to be able to reset it to the opening values after each 'option' is visualised so that the next option can be inputted, for example?

 

[Yongle]

If there is only ONE OriginalSheet then create a copy of the original sheet and work with that, then create another copy and work with that etc

Try this
Right-click on sheet tab \ click Move or Copy \ check box Create A Copy \ OK
OriginalSheet(2) is created
Amend various values in OriginalSheet(2)
Test to see that you can do all that you want

If it works for you then automate with VBA like this
1. Add the code
Right-click on sheet tab \ View Code
Paste code into that window

Sub CreateACopy()
    Me.Copy Before:=Sheets(1)
    Sheets(1).Activate
End Sub

2. {ATL}{F11} to return to Excel

3. Add a shortcut
List all macros with {ALT}{F8} \ select macro CreateACopy \ click Options \ enter Q in shortcut box \ OK

4. Macro now runs with {CTRL} Q

5. Workbook must now be saved as type MacroEnabled

 

[Madraykin]

Fabulous, that looks like it should do the trick, I'll give it a go when I'm at that stage (late tomorrow/early next week) and will report back!

Thanks for your help as always!