If the cell is not unprotected, then the contents cannot change and so the check box cannot change. The reason that you need to unprotect the cell to which the check box is linked is because the contents of the cell needs to be able to change as the status of the check box is modified. Now you can protect your workbook as you normally would, and the check boxes should work. On the Protection tab, make sure the Locked check box is cleared. Excel displays the Format Cells dialog box. (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. On the Protection tab, make sure the Locked check box is cleared.Ĭheck boxes are also linked to specific cells in a worksheet.
Excel displays the Format Control dialog box. For more information about how to protect a workbook, see Protect a worksheet. To unprotect the check box, right-click on it and choose Format Control. Why do I get an 'Unprotected Formula' message in Excel. The thing to remember in working with check boxes (from the Forms toolbar) is that there are two things you need to explicitly unprotect: the check box itself and the cell to which the check box is linked. When he protects the worksheet, the check boxes cannot be changed. Worksheet protection is a two-step process: the first step is to unlock cells that others can edit, and then you can protect the worksheet with or without a password.
He wants to protect the worksheet, but still be able to update the check boxes, but this doesn't seem to be possible. Run VBA Macros on Protected Worksheet Unprotect & Protect, UserInterfaceOnly argument Worksheet.Protect Method Step 1: Make the Sheet4 very hidden with. Dave developed a worksheet that uses yes/no check boxes, combined with a true/false statement to update another cell.
0 kommentar(er)
