VBA & Macro Problems

Stop Excel Form Controls from Moving or Overlapping Cells

Rana GarciaRana Garcia Nov 18, 2026 869 views

Question details

Keep worksheet buttons and other Form Controls from moving or overlapping data when switching sheets and entering information.

Stop Excel Form Controls from Moving or Overlapping Cells
Product
Microsoft Excel
Device & OS
not provided
Scenario
A user switches between worksheets and enters data in a VBA-enabled workbook containing Form Controls.
Observed behavior
Buttons and other controls move, overlap data, or disappear.
Before you start

Open the affected workbook in Excel and identify each control that moves or disappears. Check whether the issue occurs after entering data, switching worksheets, or changing row and column sizes.

Solution 1Recommended

Set each Form Control to stay in place

Use the control's Properties settings to prevent it from moving or resizing with worksheet cells.

1
Open the control settings

On the affected worksheet, right-click a Form Control button and select Format Control.

2
Change the positioning property

Open the Properties tab, select Don't move or size with cells, and click OK.

3
Update the other controls

Repeat Format Control > Properties for each affected button or other Form Control.

4
Test the worksheet

Switch between the affected worksheets and enter data again to check whether the controls remain in place.

Set each Form Control to stay in place
Check for overlap after layout changes: This setting keeps a control's position and size independent of cells, but it does not stop expanding rows or columns from extending underneath the control.
Free Microsoft Office alternative

Work with spreadsheets in WPS Office

WPS Office is a free, lightweight, easy-to-use alternative with a familiar spreadsheet interface and support for common Excel formats. Open existing workbooks to make migration easier, but use Excel to troubleshoot its Form Control properties and test VBA-dependent features.

Edit worksheets and manage spreadsheet data in WPS SpreadsheetsCompatible with common Microsoft Excel formats, including XLSX and XLSFamiliar interface makes it easier to move between office suitesFree and lightweight for everyday spreadsheet work
microsoft office alternative - wps office

Frequently Asked Questions

How do I stop an Excel button from moving when I resize cells?

Right-click the Form Control button, select Format Control, and open Properties. Choose Don't move or size with cells, then click OK.

Do I need to change the setting for every button?

Yes. Open Format Control > Properties for each affected Form Control and apply the setting individually.

Why does a control still overlap data after I lock its position?

Don't move or size with cells keeps the control in a fixed position, but changed row heights or column widths can still place data underneath it. Adjust the worksheet layout or move the control to a clear area.

Can a macro move a button despite its Properties setting?

Yes. In Developer > Visual Basic, check worksheet and workbook event procedures for code that changes control positions or worksheet layout.