Permission & Access Issues

Prevent an Excel Combo Box from Moving on a Protected Worksheet

Nimra MalikNimra Malik Nov 14, 2026 868 views

Question details

Prevent an Excel combo box from being moved, resized, or deleted while allowing users to make selections.

Prevent a Combo Box from Moving on a Protected Excel Worksheet
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.
Before you start

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.

Solution 1Recommended

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.

1
Unlock input cells

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.

2
Check the combo box

Right-click the combo box and open Format Control. On the Protection tab, confirm that Locked is selected, then click OK.

3
Protect the sheet

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.

4
Test the control

Click the combo box and make a selection, then try moving or resizing it. Confirm that users can also edit the unlocked input cells.

Protect the Excel worksheet without allowing object edits
Check the linked cell: If a selection cannot be written to the linked cell, unprotect the sheet and unlock that cell before protecting the sheet again. For an ActiveX combo box, also make sure Developer > Design Mode is turned off before testing.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLS and XLSX filesReview spreadsheets with a familiar tabbed interfaceUse a free, lightweight office suite for everyday workInspect workbook content when moving spreadsheet work from Excel
microsoft office alternative - wps office

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.