Protection to Allow Clear Contents but NOT Deletion

[robertgama]

I have a workbook without any VBA code, where I want to allow the user to clear the contents of the Data sheet, but I would like to prevent them from Deleting cell (right-click delete) which will break my dynamic formulas pointing to the range where new data will be pasted.

If the user presses the delete key or the Clear->Cell Contents button then everything is okay.

I guess my question would be if there is a way to enable this with protection (sheets/workbooks) without using VBA?

Thank you,

Robert.

 

[robertgama]

I'm guessing this is not possible since nobody replied?

Thanks,

Rob.