Keep Excel Option Buttons Selected on a Protected Worksheet
Question details
Allow users to select Excel Form Control option buttons on a protected worksheet and keep the selected button visible.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet uses Form Control option buttons that write a selection value to a linked cell while sheet protection is enabled.
- Observed behavior
- When the linked cell is locked, selecting an option button can produce an error and the button may not remain visually selected.
Identify the cell linked to the option button before changing worksheet protection. You can find it by right-clicking the option button, choosing Format Control, and checking the Cell link field on the Control tab.
Unlock the option button linked cell before protecting the worksheet
Use this solution when users need to select Form Control option buttons on a protected Excel worksheet.
Option buttons must be able to update their linked cell. Leaving that linked cell unlocked allows the control to save the selected value while the rest of the worksheet remains protected.
On the Excel ribbon, open Review and select Unprotect Sheet. Enter the worksheet password if Excel requests it.
Click the cell shown in the option button's Cell link setting. To verify it, right-click the option button, select Format Control, open the Control tab, and review the Cell link box.
Right-click the linked cell, select Format Cells, open the Protection tab, clear the Locked check box, and select OK.
Go to Review > Protect Sheet. Allow users to select unlocked cells, then apply protection. The option button can now update its linked cell and retain its selected appearance.

Block interaction with option buttons by covering them with a transparent shape
Use this workaround when users must view the option buttons but should not be able to click or change them on a protected sheet.
Protect option button linked cells correctly in WPS Spreadsheets
WPS Spreadsheets lets you configure cell protection and protect a worksheet while leaving the cell used by an option button available for updates. This helps interactive controls keep their selected state without exposing the rest of the worksheet for editing.
- 1. Open the worksheet in WPS Spreadsheets: Launch WPS Office, choose Spreadsheets, and open the Excel workbook containing the option buttons.
- 2. Locate the linked cell: Select the option button and review its control settings to identify the cell that stores the selected option value.
- 3. Unlock the linked cell: Select the linked cell, open Format Cells, choose the Protection settings, and clear the Locked option.
- 4. Apply worksheet protection: Use the Review or Tools protection command to protect the worksheet while permitting users to select unlocked cells.

Frequently Asked Questions
Why does an Excel option button stop showing as selected after I protect the sheet?
A Form Control option button writes its result to a linked cell. If that cell is locked under sheet protection, Excel cannot update it, which can cause an error or prevent the selected state from remaining visible.
How do I find the cell linked to an Excel option button?
Right-click the option button, choose Format Control, and open the Control tab. The Cell link field shows the worksheet cell used to store the selection value.
Should the option button itself be unlocked on a protected worksheet?
The essential setting is to unlock the linked cell. Also configure Protect Sheet to allow users to select unlocked cells so the control can update that cell during selection.
Can I hide the linked cell for an option button?
Yes. You can place the linked cell in an unused location or hide its row or column. Keep the cell unlocked so the option button can still write its selection value.
How can I stop users from changing option buttons without removing them?
Insert a rectangle over the controls, format it with 100% transparent fill and no line, then protect the worksheet without allowing object editing. The controls remain visible but cannot be clicked.




