I have scoured the web for ideas and have not found one specific enough....Here's my problem....

I have a protected, shared worksheet which will be used by several people. Purposefully, I unlocked and locked specific cells. This is a growing document with a large number of rows. I have used data validation with drop boxes in several unlocked cells, and formulas in some locked ones.

Here's what I need....After a new row of data is entered, and the user clicks save, I want all of the data values in the entire spreadsheet to "freeze." I need formulas cells (with new value) to act like they have a copy, pastespecial "value" and no longer a formula. After "save", users cannot edit the spreadsheet, this must be done by administrator.

Any help is greatly appreciated. This is also my first post to this forum, so I apologize if I did not post appropriately.

Thank you!!

Ian