format option

[JOEE1979]

I have locked the worksheet, however the clear button is still showing. How can I get rid of it so no one can use that function.
I'm trying to eliminate as much formatting so all someone can do is enter data and not mess up the sheet.

Thanks

 

[breynolds0431]

If you are adding sheet protection via VBA, then you'd use the below code to not allow formatting. Otherwise, when manually protecting, ensure the formatting options are not ticked (see image).

VBA:

Sub Protect()
    ActiveSheet.Protect AllowFormattingCells:=False, AllowFormattingColumns:=False, _
        AllowFormattingRows:=False
End Sub

Manual:

 

[JOEE1979]

those boxes are not ticked, but my guys are still able to clear the format