Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Dec 2009
    Location
    Edmonton Alberta
    Posts
    56
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Question Problem with protection of sheet that includes radio buttons

    I have a small spreadsheet that does calculations based on input of selected cells and the selection of radio buttons. This worked just fine when I made it in 2006. Now I have added to it and can not protect it the way it was. All cells were protected except those that may require input and the 6 radio buttons.

    Now I can not unlock my radio buttons.. What have I forgotten to do?

    The buttons were made from the Visual Basic Editor. If I go to Design Mode select one of the buttons under properties they are listed as: locked false. On an original.. that I did not modify, the property on that is the same. Changing the locked property to true does not fix the problem.

    Here is what I am doing > select all > format >cells > select locked and hidden. Then select all those cells I want available for input > format >cells > deselect locked and hidden. Then Tools >Protection > Protect sheet. select option to access unlocked cells.

    Now it works.. except I can not use my radio buttons and get double error messages when I do.

    Thanks for your time.. and any thoughts as to what I am forgetting to do appreciated

  2. #2
    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
    Are the cells linked to the buttons locked? They must be unlocked so that they can be changed...

    Steve

  3. The Following User Says Thank You to sdckapr For This Useful Post:

    Ralph2 (2011-11-12)

  4. #3
    Star Lounger
    Join Date
    Dec 2009
    Location
    Edmonton Alberta
    Posts
    56
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Thanks Steve
    That was the problem. My buttons set up a true / false thing and those cells were locked.

    Thanks again

Posting Permissions

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