Reset Spreadsheet Help

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.

Hi FDibbins,

First of all I would like to thank you for taking time to help me.

I have done what you advised and while it has solved the problem of stopping people from saving over the master document people will still be able to write over some of the formulas and for that reason I was wondering if there is a way to protect individual cells from being written to.

I also still need a way to reset as the form will be continually used and I don't want people to have to close and reopen after they complete every form.

Hi Cas,

With regard to point 3, I have shown below the code I used recently to clear the information from selected cells (included in the code) in a pricing spreadsheet:-

[Private Sub CommandButton2_Click()
'
Range("T2,T4,T6,P10:P28,C10:C28,G10:G28,I10:I28,K10:K28,M10:M28,E30,G30,I30,K30,C36:C45,G36:G45,K36:K45").Select
Selection.ClearContents

End Sub]

You will need to save this in VBA and link it to a Command Button.

It would be easier if you attach a copy of the spreadsheet (with sensitive information removed or changed) and I can add the above for you.

Regards

peterrc

Hi,

Again thanks to everyone who has taken time to offer assistance with my issues, it is greatly appreciated.

I have had a quick look through the responses and I believe I should be able to resolve my issues with the advice given. Unfortunately I have a busy schedule today but I will read up on some of the things suggested later and try to get my spreadsheet working as intended. I will post back later and let you know how I got on.

Cheers