Can I disable the "Delete" function in Excel (or password protect.

[softlygiggles]

Several of the worksheets I create for work have users that are very new to
Excel. They keep using Delete instead of clear contents and that messes up
formulas that I have in place. I cannot password protect these sheets (for
the boss for one reason). I would LOVE to be able to remove the option to
delete when they right click, or even have a warning appear asking them to
choose between delete and clear contents.

 

[Jason Morin]

You can disable it when the workbook opens. The second
macro re-enables it. Put both in a standard module (press
Alt+F11, Insert > Module, and paste in the code.

Sub Autpen()
CommandBars("Cell").FindControl(ID:=292).Enabled = False
End Sub

Sub Shortcut_RestoreItem()
CommandBars("Cell").Reset
End Sub