I have two columns that the user needs to update. One column is a checkbox (actually a wingding font) and the other is a cell with free data.
I want them to be able to double click on the checkbox cell but not enter any data.
I want them to be able to click on free data cell and enter data.
I have the double click event working and it even works if the cell can't be selected because of sheet protection which is perfect.
My issue is I want the free cell to be able to be selected and changed but because the sheet protection does not allow selection this cell can not be selected and changed.
Ideas on how this can be accomplished? The protect sheet function seems to override the command before to set locked = false and if I reverse it and do a locked =true after the protection of course I get an error. Can I use userinterfaceonly somehow here to solve it?
EDIT:
I thought I could use a before update event but that does not seem to be available on the sheet level.
I want them to be able to double click on the checkbox cell but not enter any data.
I want them to be able to click on free data cell and enter data.
I have the double click event working and it even works if the cell can't be selected because of sheet protection which is perfect.
My issue is I want the free cell to be able to be selected and changed but because the sheet protection does not allow selection this cell can not be selected and changed.
Ideas on how this can be accomplished? The protect sheet function seems to override the command before to set locked = false and if I reverse it and do a locked =true after the protection of course I get an error. Can I use userinterfaceonly somehow here to solve it?
EDIT:
I thought I could use a before update event but that does not seem to be available on the sheet level.
Last edited by a moderator:
