Make fields uneditable in worksheet of an excel sheet

[Nikhil2803]

Hi Team, Greetings! I need a help here, I have created an excel template in which the workbook has n numbers of checkboxes. I don't want end users to do the right click and change the checkbox properties. I want to lock all the checkboxes so that users can only check or uncheck the checkboxes but they should not edit it i.e. right click should not work for the,. Could you please advise how to achieve this.

 

[John_w]

Simply protect the worksheet. You don't even have to lock the cells in which the checkboxes sit.