Office Settings & Configuration

How to Use a Form Control List Box on a Protected Excel Sheet

Khadija KhanKhadija Khan Nov 10, 2026 870 views

Question details

The user wants to allow interaction with a Form Control List Box even when the Excel worksheet is protected.

How to Use a Form Control List Box on a Protected Excel Sheet
Product
Microsoft Excel
Device & OS
not provided
Scenario
Securing a worksheet while retaining the functionality of interactive form controls like list boxes for data selection.
Observed behavior
By default, protecting a sheet locks all cells and objects, preventing users from making selections in a Form Control List Box unless its linked cell is properly configured.
Before you start

Before proceeding, identify the specific cell that is currently linked to your List Box, as you will need to change its locking properties before enabling sheet protection.

Solution 1Recommended

Unlock the Linked Cell for the List Box

By unlocking the cell that stores the List Box's selected index, users can still click and select items after the worksheet is protected.

Form Control List Boxes rely on a linked cell to output the index number of the selected item. When sheet protection is activated, any attempt to change a locked cell is blocked. By unlocking only this specific linked cell, the List Box can successfully update the value, allowing it to function normally on a secured sheet.

1
Identify the Linked Cell

Right-click the Form Control List Box and select "Format Control". Navigate to the "Control" tab and look at the cell reference in the "Cell link" box. Note this cell address and click OK.

2
Open the Format Cells Dialog

Select the cell you just identified as the Cell link on your worksheet. Right-click the cell and choose "Format Cells" from the context menu.

3
Unlock the Cell

In the Format Cells dialog box, navigate to the "Protection" tab. Uncheck the "Locked" checkbox and click OK to apply the change.

4
Protect the Worksheet

Go to the "Review" tab on the top ribbon and click "Protect Sheet". Ensure that the option to "Select unlocked cells" is checked, set a password if desired, and click OK. The List Box will now remain interactive while the rest of the sheet is secured.

Unlock the Linked Cell for the List Box
ActiveX Control Not Required: An ActiveX List Box is not required for this setup. A standard Form Control List Box works perfectly and is generally more stable across different versions of Excel.
WPS Spreadsheet for Data Security

Create and Protect Interactive Spreadsheets with WPS Office

WPS Spreadsheet offers robust form controls and sheet protection features, allowing you to build interactive dashboards and data entry forms while keeping your formulas and layouts perfectly secure.

  1. 1. Insert a List Box: Open your file in WPS Spreadsheet, go to the Developer tab, click "Insert", and choose the List Box Form Control.
  2. 2. Link to a Cell: Right-click the inserted List Box, select "Format Control", and assign your desired "Cell link".
  3. 3. Unlock the Linked Cell: Right-click the linked cell, choose "Format Cells", navigate to the "Protection" tab, and uncheck "Locked".
  4. 4. Protect the Sheet: Navigate to the "Review" tab, click "Protect Sheet", and apply your security settings so users can interact with the List Box safely.
Fully compatible with Microsoft Excel (.xlsx) formatsEasily insert and configure Form Controls like List Boxes and Combo BoxesAdvanced sheet protection to secure sensitive data without breaking interactivityFree and lightweight office suite for seamless data management
microsoft office alternative - wps office

Frequently Asked Questions

Do I need to use an ActiveX List Box instead of a Form Control List Box?

No, an ActiveX control is not required for this setup. A standard Form Control List Box works perfectly on a protected sheet as long as its linked cell is unlocked.

Why is my List Box still unclickable after unlocking the linked cell?

Ensure that your worksheet protection settings are configured correctly. When protecting the sheet, make sure "Edit objects" is checked if you want users to be able to interact with the control box itself, although just unlocking the linked cell is usually sufficient for Form Controls.

How do I hide the linked cell so users can't see the index number?

You can hide the index number by selecting the linked cell, opening "Format Cells", going to the "Number" tab, choosing "Custom", and typing three semicolons (;;;) in the Type box. Alternatively, place the linked cell on a separate hidden worksheet or format the font color to match the cell background.