Results 1 to 5 of 5
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Unprotect check box

    I have tried both an ActiveX check box and a Form Control check box.
    I have set the properties for them to be unprotected. However, when I protect the sheet, and click on one or the other box, I STILL get the warning that it's protected.

    What dumb thing am I overlooking?

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    I tried adding a check box with the Forms Toolbar and had no problem using the check box after protecting the Sheet only then also protecting the workbook & sheet.

    I did this with Excel 2003. You didn't mention what version you were using.

    P.S. There is no password.

    see attached.
    Attached Files Attached Files
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Do you have the checkbox linked to a cell? If so the the linked cell must be unlocked so the control can change its value...

    Steve

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Yes, that's it! Ah Ha...thanks.

  5. #5
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Quote Originally Posted by sdckapr View Post
    Do you have the checkbox linked to a cell? If so the the linked cell must be unlocked so the control can change its value...

    Steve
    Thanks Steve, missed that one completely!
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •