D
David
Hello All, Hope you are well,
Got 2 question about checkboxes
1st.
How do you get them to work on a cell when that cell is locked and
protected.
If you link them to a cell that is locked and protected (trust me, they need
to stay protected) it will not change the cell unless you unlock the linked
cell itself.
2nd.
Can you use a checkbox to lock/unlock a specific cell by its state if the
sheet is protected, meaning that if it was true the cell would be unlocked,
and if it was false it would be locked, keep in mind the sheet is protected
Got 2 question about checkboxes
1st.
How do you get them to work on a cell when that cell is locked and
protected.
If you link them to a cell that is locked and protected (trust me, they need
to stay protected) it will not change the cell unless you unlock the linked
cell itself.
2nd.
Can you use a checkbox to lock/unlock a specific cell by its state if the
sheet is protected, meaning that if it was true the cell would be unlocked,
and if it was false it would be locked, keep in mind the sheet is protected