-
Want 2 Protect sheet - but Checkboxes are too :(
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.
Is there a way around this?
Thank you once again
Irene
-
Make sure that the cells that are used as the Cell Links for the Check Boxs are all unlocked.
-
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
-
You're Welcome
Take Care
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules