Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Sheet Protection / Forms (XL2003)

    Looking at the screen snipet below, I have applied protection to this sheet. Prior to applying protection, I unlocked all of the yellow cells as this is where the user would enter info. It is also necessary for the user to be able to make changes to values in the combo boxes and option buttons. I have right clicked on every option button, Format Control | Protection | and unlocked... Same with the combo boxes. Still, I am unable to make changes to those forms while the sheet is protected.

    The sheet is of no use if I can't protect it and still make choices using the forms I've put on the sheet.
    - Ricky

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Sheet Protection / Forms (XL2003)

    Okay. I tinkered around and found the solution. I started to just delete the question but I reckoned that someone else may benefit from the answer.

    Unlocking the forms is not what needs to be done. In fact, the forms should be LOCKED to prevent moving them, resizing them, etc.
    To make the forms "work", you must unlock the cell that is linked to the forms. In my own example, several cells on row 23 were used as the link and those had to be unlocked, otherwise sheet protection would keep the value from changing.

    <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17> I wonder if I'm the first lounger to ask a question and then answer it?
    - Ricky

  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

    Re: Sheet Protection / Forms (XL2003)

    Congrats on finding the solution yourself. Yes the linked cell must be unprotected since as you surmised if the linked cell is not, it is protected and thus can not be changed.

    PS. No you are not the first to answer your own question. It happens on occasion and it is appreciated so that others may learn from the answer.

    Steve

Posting Permissions

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