Dave Punky
Board Regular
- Joined
- Jan 7, 2010
- Messages
- 133
Hi all,
I'm not sure if it's possible to do this but I thought I would ask to see the best way of doing it if it was.
Basically I want to protect a block of cells from being edited when a checkbox is ticked. The information can be copied, but not physically edited unless the checkbox was clear.
Essentially this box would make these cells read only when checked, and fully writable when unchecked - I can't do this with the whole spreadsheet as data will continually be entered into it.
For example, the cells I want to protect are A1:G20, and if the box is unchecked they would be completly editable, but if the box is checked, you can only view what's there, copy the information that is there but would be unable to manually edit the information.
Is it possible to do this, or is it just madness?
I'm not sure if it's possible to do this but I thought I would ask to see the best way of doing it if it was.
Basically I want to protect a block of cells from being edited when a checkbox is ticked. The information can be copied, but not physically edited unless the checkbox was clear.
Essentially this box would make these cells read only when checked, and fully writable when unchecked - I can't do this with the whole spreadsheet as data will continually be entered into it.
For example, the cells I want to protect are A1:G20, and if the box is unchecked they would be completly editable, but if the box is checked, you can only view what's there, copy the information that is there but would be unable to manually edit the information.
Is it possible to do this, or is it just madness?