making default excel

Microsoft Office 2007 professional (aca...
June 23, 2010 at 17:15:27
Specs: Windows
hi dear office users out there, i was wondering if the excel file can be set to a default button such that after finishing keying the values in the cell, the user can just hit a button or choose to go back to the original state. Is it possible to do this?

See More: making default excel

Report •

June 23, 2010 at 17:24:41

Is there a reason to undo entries with a special button.
Excel already has an Undo function, and there is the option to undo a series of actions.

Do you need more than this, and if so how is the initial state determined.

If data is entered, then there is a pause and more data is entered, how far do you go back - to the state before the second lot of data entry or to the state before the first lot of data entry, or ....where/when

Do you want to re-load the worksheet, and if so will you need to stop everyone from saving any changes.

Let us have more information to help offer a possible solution.


Report •

June 23, 2010 at 18:38:17
i was hoping if the user have to input more than ten sheets of data and after clicking a button that will go back to the initial state. It will be alot of data. i know saving the file would help but sometimes other users who will be using the file will accidentally overwrite this save default file. Hence i am thinking whether there will be an alternative solution.

Report •

June 24, 2010 at 04:22:51

You will have to be a lot more specific about this.

I still do not understand why you want a user who has entered ten sheets of data to be able to click a button and return to an initial state and lose all of those ten sheets of data entry.

What is the point of clicking this button.


Report •

Related Solutions

June 24, 2010 at 06:27:16
re: accidentally overwrite this save default file

Are you saying that you have a "template" and that users are overwriting that file instead of saving their own version, with their own data?

If so, you could protect the workbook and then force the users to save the workbook under a new name before they could do any data entry. The code would save the "new" file, under a name that either they provide or you force into the code. The new file would be saved in an unprotected state. The new file would stay open and allow for data entry.

Would that work for you?

Report •

Ask Question