excel for mac can't click with dialog box

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. The dialog window will appear, where you can enter name for a data range and a range of cells: Another way is to click Insert>Name>Define and modify,add,or delete data ranges names. However, you can call it by pressing + fn + F3. On the Protection tab, make sure the Locked check box is cleared.Ĭheck boxes are also linked to specific cells in a worksheet. There is no special button for the Name Manager in any version of Excel for Mac. Excel displays the Format Control dialog box. To unprotect the check box, right-click on it and choose Format Control. Application.Dialogs(xlDialogPrint). 'On top' both in the sense that no subordinate dialog needs to be invoked and it is above all the other options on the Print Dialog box. 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. In that case, that functionality is 'on the top' of the normal Print screen for Mac.

When he protects the worksheet, the check boxes cannot be changed. He wants to protect the worksheet, but still be able to update the check boxes, but this doesn't seem to be possible. Dave developed a worksheet that uses yes/no check boxes, combined with a true/false statement to update another cell.

Excel for mac can't click with dialog box