Lock and Unlock sheets in a shared workbook?

[Dulanic]

I have a shared workbook which is used for data entry. Once each person is done they press a button which I designed to then transfer the data from their individual worksheet. Here is where my issue is, I move the data to a "mass" sheet that keeps all the submitted data. This is how I originally planned to do this... until I found out you can't unlock or relock a sheet when a workbook is shared? I need to keep some of the sheets locked otherwise they could change stuff by accident or just do something incorrect. Any ideas for work around?

Please Login or Register  to view this content.

Maybe I guess I keep the Master Data list on a different workbook? My problem is if I also use Conditional formatting to let them know if they already entered the data. I use this formula to verify using a named range on the "SubmittedData" worksheet....

=IF($C3<>"",COUNTIF(SubmittedData,$M3)>0)