Hi,

I have made a form using Excel 2007 and I am nearing completion. However, I have a couple of issues I need to resolve before the task is completed. The issue I am trying to resolve at the moment is as follow:

1. I have my form completed and saved with none of the fields completed.
2. When someone uses the form they are going to fill in certain fields and make changes to the spreadsheet.
3. After they do this I want to create a button that resets the form back to its initial state.

Therefore, I was wondering how I go about creating a button [or alternative method] that resets the spreadsheet back to its initial state.

I also want to prevent people from saving the spreadsheet or making changes to certain cells.

Any help or advise would be greatly appreciated.