+ Reply to Thread
Results 1 to 3 of 3

Button to return entire workbook to it's initial state

Hybrid View

  1. #1
    Registered User
    Join Date
    06-11-2013
    Location
    Indiana, PA
    MS-Off Ver
    MS365 Version 2209
    Posts
    29

    Button to return entire workbook to it's initial state

    Hello,

    I have a workbook with a master control sheet. It's full of spin button toggles.

    What I want to do, is create a button that will reset the entire sheet; all and any of the changed values, back to what they are in the original document.

    I attached a screenshot in order to give an idea of the sheet that needs reset. Values, like in the screenshot will all be changed on a front control sheet. They affect 120+ formla-linked sheets. I want to be able to have a button that sets all values on this control sheet to what I now have, no matter the changes that someone makes. Even if they save the workbook with the values changed, they could open it and hit the button back to these values.

    Is there a way to do this easily with vba, not having to code all of the cells equal to values? There are about 1500 cells.


    Thank you so much in advance!


    Will
    Attached Images Attached Images

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,078

    Re: Button to return entire workbook to it's initial state

    You could maybe use the Workbook Open Event handler to make a copy of the sheets. Then your button could restore the copy … or you could use the Workbook BeforeClose Event handler to do the restore (belt and braces). I can't think of any other way of doing it, particularly if you are using macros.

    It might also depend on how the sheets interact with each other
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Question Re: Button to return entire workbook to it's initial state


    Hello,

    'initial state' does not exist under Excel as it is very not a database software so why not using a specific backup workbook ?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to Look up entire workbook and return results
    By Shellybelly in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-04-2016, 03:16 AM
  2. How do I search entire workbook and return a value on another worksheet
    By call2014 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-20-2014, 03:48 AM
  3. [SOLVED] Macro Button to send Entire Workbook as PDF via email
    By Rosco88 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-21-2013, 10:08 AM
  4. [SOLVED] Return Toggle Button to default state
    By Nu2Java in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-29-2012, 04:51 PM
  5. [SOLVED] Toggle Button 'State' Problem on Workbook Open
    By HangMan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2012, 06:35 AM
  6. Boolean variable initial state
    By Phil_V in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-15-2009, 08:31 AM
  7. Search entire workbook with control button
    By lock-e73 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 01-27-2008, 03:27 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1