Reset worksheet

G

gavmer

Hi all,

I was curious to know if there was a way to create a click event tha
willl reset a workbook to its original state (IE: to the book
saved/opened state)

The books name is Quote.

Cheers in advance!!!
 
B

BrianB

I suggest Close with savechanges =False.
If you want to immediately re-open then the macro will need to be i
another workbook of course (personal.xls ?)
 
T

Tom Ogilvy

If you write the code in the click event to change everything back.

Or, if you run the button from another workbook (perhaps a button on a
menu/commandbar) that closes the subject workbook without saving and reopens
it.
 
Top