I want to protect an excel sheet but allow the option buttons I have in it to be used, while the sheet is protected. The aim is to make an interactive form as shown in the photo attached. Currently when I protect the sheet I have ticked "locked cells", "unlocked cells" and "edit objects". But when I try use the object buttons after I protected the sheet I get the following message "The cell or chart you're trying to change is on a protected sheet. To make a change, unprotect the sheet. You might be requested to enter a password". I'm assuming I will have to use some VBA code to solve this issue. Can you help me please.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Use option buttons on a protected excel sheet
- Thread starter briancrow
- Start date
