MoosePuck
08-07-2004, 03:45 PM
Hi again.
the first part of my task is marked Solved at http://www.vbaexpress.com/forum/showthread.php?t=632
so I thought I should start a new one to continue.
I want to protect the Text in the cells, and the Totals from being modified, so I have locked them in the Cell properties.
BUT
if I protect my sheet, the Checkboxes are also protected & can't be changed.
In the Checkbox properties I have unchecked both Lock Text and Lock (and a combo)
In the Security properties for the sheet I have tried checking and unchecking all of them (Contencts, Objects, Scenerios) but everything locks the checkboxes.
:dunno Is there a way around this?
Thank you once again
Irene
the first part of my task is marked Solved at http://www.vbaexpress.com/forum/showthread.php?t=632
so I thought I should start a new one to continue.
I want to protect the Text in the cells, and the Totals from being modified, so I have locked them in the Cell properties.
BUT
if I protect my sheet, the Checkboxes are also protected & can't be changed.
In the Checkbox properties I have unchecked both Lock Text and Lock (and a combo)
In the Security properties for the sheet I have tried checking and unchecking all of them (Contencts, Objects, Scenerios) but everything locks the checkboxes.
:dunno Is there a way around this?
Thank you once again
Irene