Lock Up Checkbox Charter For Free

Go to the Protection tab and uncheck Locked option and click Ok. Now select only the cells or columns, rows that you want to protect. Right click and choose Format cells again. Go to the protection tab and check Locked option and click Ok.

To fix the position of a checkbox in the sheet from the cells, right-click the checkbox, then click Format Control from the context menu. From the Format Control window, select Don't move or size with cells from the Properties tab.

To unprotect the check box, right-click on it and choose Format Control. Excel displays the Format Control dialog box. On the Protection tab, make sure the Locked check box is cleared. Check boxes are also linked to specific cells in a worksheet.

Excel displays the Format Control dialog box, on which you should select the Properties tab. Just click the radio button that reflects the behavior you want for the control?in most cases you'll click Don't Move or Size with Cells.

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.

Now, select the cells you want to lock. Right-click and then click format cells. On the protection tab, check the locked checkbox and then click OK.

Select the control that you want to protect. For more information, see Select or deselect controls on a worksheet. To prevent a user from moving, sizing, or deleting a control, right-click the selection, and then click Format Control. On the Protection tab, select the Locked check box.