+ Reply to Thread
Results 1 to 9 of 9

How to select optionbutton on protected sheet

  1. #1
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    2,586

    How to select optionbutton on protected sheet

    Hi, i have a worksheet that contains text boxes and option buttons and i would like to protect the sheet so no one can "mess" with it. But when i protect the sheet one can not input data into the text boxes or select option buttons. Is there any way to protectg the sheet but allow the user to select options and input text into text boxes.

    i am enclosing a file. this file has the worksheet already protected the password for the sheet is 123

    Any ideas would be appreaciated
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    07-05-2012
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2016
    Posts
    165

    Re: How to select optionbutton on protected sheet

    With the sheet unlocked and the Design Mode on, select each item and change the Locked property to False. Then re-lock sheet.
    Click on the * icon if this post has been helpful.

  3. #3
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    2,586

    Re: How to select optionbutton on protected sheet

    that does indeed work thank you.

    one question though.......and this may not be doable............

    when i did as you said....set the lock property to "False" for each item..........and then protect the sheet........

    if i then go into design mode .......i can move the items around.......i suppose there is no way to prevent the user from movign the items around.......this is a minor point but just wanted to check......

    thanks again.

  4. #4
    Forum Contributor
    Join Date
    07-05-2012
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2016
    Posts
    165

    Re: How to select optionbutton on protected sheet

    As far as I know, if someone has the developer tab enabled and design mode on there is no way to stop them.

  5. #5
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to select optionbutton on protected sheet

    But when i protect the sheet one cannot ... select option buttons.
    Unlock the linked cells.
    Entia non sunt multiplicanda sine necessitate

  6. #6
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    2,586

    Re: How to select optionbutton on protected sheet

    shg, not sure what you're telling me to do. can you tell me a little more.

    thanks.

  7. #7
    Forum Contributor
    Join Date
    08-22-2012
    Location
    nj, us
    MS-Off Ver
    Excel 2010
    Posts
    163

    Re: How to select optionbutton on protected sheet

    you have to unprotect sheet to move

    ---------- Post added at 10:13 AM ---------- Previous post was at 10:12 AM ----------

    you should be able to enter data and select right now, even if u don't unprotect

    ---------- Post added at 10:13 AM ---------- Previous post was at 10:13 AM ----------

    i could when i tried

  8. #8
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to select optionbutton on protected sheet

    If the option button has a linked cell, and the cell is locked, then you will be unable to change the control when the sheet is protected. Unlock the linked cell.

  9. #9
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,100

    Re: How to select optionbutton on protected sheet

    Why don't you consider doing it all via a UserForm?
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1