Office Settings & Configuration

Keep Excel Option Buttons Selected on a Protected Worksheet

Huma Ashraf ChHuma Ashraf Ch Nov 12, 2026 870 views

Question details

Allow users to select Excel Form Control option buttons on a protected worksheet and keep the selected button visible.

Keep Excel Option Buttons Selected on a Protected Worksheet
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.
Before you start

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.

Solution 1Recommended

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.

1
Unprotect the worksheet

On the Excel ribbon, open Review and select Unprotect Sheet. Enter the worksheet password if Excel requests it.

2
Select the linked cell

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.

3
Clear the Locked setting

Right-click the linked cell, select Format Cells, open the Protection tab, clear the Locked check box, and select OK.

4
Protect the sheet again

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.

Unlock the option button linked cell before protecting the worksheet
The linked cell can remain out of view: You can place the linked cell in an unused area of the worksheet or hide its row or column, as long as the cell itself is unlocked.
WPS Spreadsheets worksheet protection

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. 1. Open the worksheet in WPS Spreadsheets: Launch WPS Office, choose Spreadsheets, and open the Excel workbook containing the option buttons.
  2. 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. 3. Unlock the linked cell: Select the linked cell, open Format Cells, choose the Protection settings, and clear the Locked option.
  4. 4. Apply worksheet protection: Use the Review or Tools protection command to protect the worksheet while permitting users to select unlocked cells.
Lock formulas and worksheet content while allowing option button selections to update their linked cell.Use worksheet protection controls in a familiar spreadsheet interface.Open and edit Microsoft Excel .xlsx and .xls workbooks with strong format compatibility.Work with a free, lightweight office suite for spreadsheet tasks.
microsoft office alternative - wps office

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.