Is there a way to disable the "Clear Contents" option when right clicking on
a cell.

Basically I have spreadsheet which has lots of data validations and formulas
so the worksheets are protected. Each row of data represnts information about
a specific project. The sheet protection does not allow users to delete rows
or columns, but conetnets can be cleared leaving blank cells. I do not want
users to have the ability to clear contents of cells once data has been
entered. Yes they can click the cell and manually override the information eg
if a date changes etc, but I do not want the contents to be cleared once data
has been entered.

Is there a macro or vba code which can disable the "Clear Contents" option
in the right mouse button menu.

I dont want users clearing conetnts of cells to pretend that projects did
not exist etc or if a project is cancelled we still want to have visibility
that it was planned at one stage. Basically once information has been entered
into a cell it cannot be cleared. This will only apply to specific cells, not
all cells in the worksheet.

Please help?