Query Related To enable edit but deceble delete

If you really want to limit what a person can do, use user forms to "isolate" them from the sheet.

Create the sheet and then protect it. Let the person select the cell to edit. Then either click a button or use a shortcut key to launch the form. If the user selects a cell in a column that is not valid, pop up an error message and do not launch the form.

Then check to see if the person has already edited the record on this row by checking a helper column added for this purpose.

If both of those conditions pass, then populate the form with appropriate information and have the user fill in the information on the form. On commit, unprotect the sheet, write the data and reprotect the sheet. Also put something (user ID) in the helper column to indicate that the record has already been edited.