Lock Checkbox Log For Free

The CheckBox options can be restricted from being changed to the checked or unchecked state by using the CheckBoxClick event when the CheckBox cell is clicked.

In the Protected Sheet dialogue box, make sure that the Locked option is selected for both the cells with check boxes and the cells that are linked to them. Then, click OK. Your worksheet is now protected and users will not be able to change any data or delete any check boxes.

JavaScript Code Define a function named ?readOnly()?. In its definition, the ?checkbox? variable applies the ?getElementById()? method to access the given checkbox using its id ?field1?. Lastly, set the status of the ?disabled? property by specifying its value ?true? which disables the accessed checkbox.

On the worksheet, select just the cells that you want to lock. Bring up the Format Cells popup window again (Ctrl+Shift+F). This time, on the Protection tab, check the Locked box and then click OK. On the Review tab, click Protect Sheet.

With the required cells selected, press Ctrl + 1 to open the Format Cells dialog (or right-click the selected cells and click Format Cells), switch to the Protection tab, and check the Locked checkbox.

On the Protection tab, make sure the Locked check box is cleared. Check boxes are also linked to specific cells in a worksheet. (See the Control tab of the Format Control dialog box.) To unprotect the cell to which the check box is linked, select the cell and choose Cells from the Format menu.

When the disabled option is added to the input tag, the checkbox is essentially disabled so you can view the checkbox but cannot interact with it. You can also use the 'checked' option and get the read-only checkbox which is already checked but cannot be unchecked.