Prevent an Excel Combo Box from Moving on a Protected Worksheet
Question details
Prevent an Excel combo box from being moved, resized, or deleted while allowing users to make selections.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet contains a combo box that users need to operate without changing its position or size.
- Observed behavior
- The combo box can still be moved, resized, or deleted despite being locked and set not to move with cells.
Identify the cells users must edit and any cell linked to the combo box. If the worksheet is already protected, use Review > Unprotect Sheet and enter the password if prompted.
Protect the Excel worksheet without allowing object edits
Use worksheet protection to prevent changes to the combo box while leaving the necessary cells available for input.
Select the cells users need to edit, including the combo box's linked cell if it must receive a value. Open Format Cells, select the Protection tab, clear Locked, and click OK.
Right-click the combo box and open Format Control. On the Protection tab, confirm that Locked is selected, then click OK.
Go to Review > Protect Sheet. In the list of allowed actions, clear Edit objects, then click OK. Enter and confirm a password if you choose to use one.
Click the combo box and make a selection, then try moving or resizing it. Confirm that users can also edit the unlocked input cells.

Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative for opening and editing Excel files in a familiar interface, making it easier to move everyday spreadsheet work between office suites. Test protected worksheets and combo boxes for compatibility before sharing them.

Frequently Asked Questions
Why can my locked combo box still be moved?
The Locked setting takes effect when worksheet protection is enabled. Go to Review > Protect Sheet and make sure Edit objects is not allowed.
Will unlocking cells let users move the combo box?
No. Unlocking cells allows users to edit those cells on a protected sheet; it does not grant permission to edit objects when Edit objects is cleared.
Why won't the combo box save my selection?
Its linked cell may be locked. Use Review > Unprotect Sheet, unlock the linked cell through Format Cells > Protection, and protect the sheet again.
How do I change the combo box after protecting the sheet?
Go to Review > Unprotect Sheet and enter the password if prompted. Make your changes, then use Review > Protect Sheet and clear Edit objects again.




