Hi,

I've created a data entry form in Excel 2016 for easy use for a couple of people. However, the spreadsheet has been corrupted several times by those inputting the data (records missing, data in wrong cells, etc). I've tried to lock the cells that already had data in them and then protect the sheet. But I can't use the data entry form to create a new record when I do this. I can only use criteria,find next,find previous and close.

Is there a way that I can protect the cells in the spreadsheet that has data in it but still be able to use all functions of the data entry form (ie: specifically New, Delete, Restore) to create new records?

Any other suggestions?


Thanks,
Jae