I have a range of cells with checkboxes attached to them. I have these cells locked. The workbook is shared so that multiple users can work on the sheets.
I also used the "Allow users to edit ranges" features to give certain users the ability to edit these cells.
If they type directly in the cell, everything is ok. If they click on the checkbox linked to the cell, it says the cell is protected and prevents the change, even though they are allowed to via the "Allow users to edit ranges" feeature.
How can I have the checkboxes work while the sheet is protected?
Bookmarks