How to Use a Form Control List Box on a Protected Excel Sheet
Question details
The user wants to allow interaction with a Form Control List Box even when the Excel worksheet is protected.

- 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 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.
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.
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.
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.
In the Format Cells dialog box, navigate to the "Protection" tab. Uncheck the "Locked" checkbox and click OK to apply the change.
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.

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. 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. Link to a Cell: Right-click the inserted List Box, select "Format Control", and assign your desired "Cell link".
- 3. Unlock the Linked Cell: Right-click the linked cell, choose "Format Cells", navigate to the "Protection" tab, and uncheck "Locked".
- 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.

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.




