Excel Question

Discussion in 'Windows Desktop Systems' started by Sinster, Sep 8, 2004.

  1. Sinster

    Sinster Moderator

    Messages:
    520
    Location:
    M*ssholechusetts
    I want to use check boxes. I have "Protected" the sheet. How do I go about add a check mark when I click on the Check box? If I unprotect the cells I can't add the check mark and when I do click on the check box I can adjust the size of it. I don't want that.
     
  2. dadecamp

    dadecamp under worked, over paid

    Messages:
    123
    Location:
    Arizona desert
    You need to unlock the cells that you want to put the checkmark in. Select the cells (hold the ctrl key if more than one). Do Format, Cells.., Protection, un-check Locked. Of coarse the sheet needs to be un-protected while doing this.
    After re-protecting the sheet the cells can then be used and you can move from one of the cells to the next by using Tab..
     
  3. Sinster

    Sinster Moderator

    Messages:
    520
    Location:
    M*ssholechusetts
    I tried that but I still can't put Checks in the "Check Box". If I double click the "Check Box" a VB Window appears.
     
  4. Khayman

    Khayman I'm sorry Hal... Political User Folding Team

    Messages:
    5,518
    Location:
    England
    Which version of excel are you using. i have 2003, and when i add a check box it ticks just fine with the sheet protected or not
     
  5. Sinster

    Sinster Moderator

    Messages:
    520
    Location:
    M*ssholechusetts
    I am running 2003. When I try to use it as a check box, all it does is put the adjustment marks around it.
     
  6. Sinster

    Sinster Moderator

    Messages:
    520
    Location:
    M*ssholechusetts
    I got it... I didn't have macro's enabled.