Protecting Controls in a worksheet

[Guest]

Hi All,
I have placed Checkbox controls in a spreadsheet and would like to protect
it. When I protect the workbook, I can only use some Checkboxes and not all.
Some Checkboxes give me an error that the "..Cell or Chart is protected..and
hence Read-Only..". i have tried may combinations to get the desired results
but have not succeeded. I require you help as I am in Dire Straits.
Thanks in advance.

 

[Jim Rech]

If you've linked the check box to a cell make sure the cell is unlocked.

--
Jim
| Hi All,
| I have placed Checkbox controls in a spreadsheet and would like to protect
| it. When I protect the workbook, I can only use some Checkboxes and not
all.
| Some Checkboxes give me an error that the "..Cell or Chart is
protected..and
| hence Read-Only..". i have tried may combinations to get the desired
results
| but have not succeeded. I require you help as I am in Dire Straits.
| Thanks in advance.

 

[Guest]

Thanks Jim. It worked.