Use option buttons on a protected excel sheet

Question

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.

Answer 1

Unprotect the sheet

Right-click the Optionbutton and choose "Format Control"

In the Protection tab uncheck "Locked"

Do that with all Optionbuttons

Each Optionbutton can have a different linked cell.

If you format the Optionbutton look into the Control tab which cell you have in "Cell link".

In the sheet, right-click these cells and choose "Format cells"

In the Protection tab uncheck "Locked"

Protect your sheet

Your sheet should work.

Otherwise you might have other links to protected controls or VBA code that wants to change something or...

In this case we need to see your file.

Andreas.

Answer 2

That worked, thank you.