PDA

View Full Version : [SOLVED] Want 2 Protect sheet - but Checkboxes are too :(



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

Jacob Hilderbrand
08-07-2004, 04:28 PM
Make sure that the cells that are used as the Cell Links for the Check Boxs are all unlocked.

MoosePuck
08-07-2004, 04:32 PM
Jacob

I have had the best day thanks to you and this terrific site :)

That was the ticket exactly!

This entire task is complete, and I am off to relax!

Thank you so much!!!!!!

Irene

Jacob Hilderbrand
08-07-2004, 04:33 PM
You're Welcome :)

Take Care