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
Bookmarks