VBA & Macro Problems

Stop Combo Boxes from Changing Size in Excel 2013

Steve KSteve K Nov 20, 2026 869 views

Question details

The user needs to stop Excel 2013 combo boxes from changing size when selected.

Stop Combo Boxes from Changing Size in Excel 2013
Product
Microsoft Excel 2013
Device & OS
not provided
Scenario
The user selects ActiveX or form combo boxes in a worksheet, potentially in a macro-enabled workbook.
Observed behavior
Some combo boxes grow or shrink when clicked, and protecting the sheet does not necessarily stop the changes.
Before you start

Identify whether the affected controls are ActiveX or form controls, and note whether resizing happens when you click them or change row and column dimensions. If the Developer tab is hidden, enable it through File > Options > Customize Ribbon.

Solution 1Recommended

Check Combo Box Placement and Worksheet Protection

Use this approach to prevent controls from resizing with worksheet cells and to test whether protection affects the behavior.

1
Select the control

On the Developer tab, turn on Design Mode for an ActiveX combo box. For a form control, right-click the combo box directly.

2
Change its placement

Right-click the combo box and choose Format Control. On the Properties tab, select Don't move or size with cells, then click OK.

3
Test sheet protection

On the Review tab, choose Protect Sheet and set the permissions needed for your worksheet. Turn off Design Mode if applicable, then click the combo box several times to test it.

4
Adjust if the control is unusable

If protection prevents interaction, choose Review > Unprotect Sheet and check the control's Locked setting in Format Control before testing protection again.

Check Combo Box Placement and Worksheet Protection
Protection may not resolve resizing: Sheet protection can restrict changes to objects, but it is not a guaranteed fix for controls that resize when clicked.
Free Microsoft Office alternative

Work with Excel Spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Excel formats, making it easier to move everyday spreadsheet work between suites. It does not repair Excel 2013 controls, and macro and ActiveX behavior may differ.

Open and edit common spreadsheet files, including Excel XLSX filesUse a familiar spreadsheet interface for everyday workbook tasksWork with worksheet data without relying on Excel combo boxesUse a free, lightweight office suite for everyday files
microsoft office alternative - wps office

Frequently Asked Questions

Why does my combo box resize when I change column widths?

Its placement may be set to move or size with cells. Right-click the control, choose Format Control > Properties, and select Don't move or size with cells.

Will protecting the worksheet always stop combo boxes from resizing?

No. Protection can restrict changes to objects but may not stop a display or control-related resizing issue. If the problem continues, check display scaling, VBA event code, and add-ins.

Where can I check whether a macro changes a combo box's size?

Press Alt+F11 to open the VBA editor, then inspect the worksheet and control event procedures for assignments to the control's Width or Height.

Can WPS Office fix an Excel 2013 ActiveX combo box?

No. WPS Office is an alternative for working with spreadsheets, not a repair tool for Excel. Test any workbook that depends on ActiveX controls or macros before relying on it in another application.