J
john
Hi,
it is not the check box that needs to be unlocked, it is
the cell that it is linked to.
Just set the linked cell to be unlocked, you can then
protect the sheet and still use the checkbox.
If you want to ensure that a user can type nothing else
into the linked cell except a "true" or "false" value then
use data validation on the cell also.
HTH,
John
it is not the check box that needs to be unlocked, it is
the cell that it is linked to.
Just set the linked cell to be unlocked, you can then
protect the sheet and still use the checkbox.
If you want to ensure that a user can type nothing else
into the linked cell except a "true" or "false" value then
use data validation on the cell also.
HTH,
John