Consulting

Results 1 to 4 of 4

Thread: Want 2 Protect sheet - but Checkboxes are too :(

  1. #1

    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

  2. #2
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    Make sure that the cells that are used as the Cell Links for the Check Boxs are all unlocked.

  3. #3
    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

  4. #4
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    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
  •