VBA & Macro Problems

Fix Excel ActiveX Controls After Hiding and Showing Rows

Elise WilliamsElise Williams Nov 20, 2026 869 views

Question details

Restore Excel ActiveX controls that stop responding or appear in the wrong position after worksheet rows are hidden and shown.

Fix Excel ActiveX Controls After Hiding and Showing Rows
Product
Microsoft Excel
Device & OS
not provided
Scenario
A worksheet contains ActiveX check boxes, command buttons, or text boxes, and the user hides and later shows rows.
Observed behavior
Controls may become unresponsive or move to incorrect positions after the rows are shown again.
Before you start

Show the affected rows before checking the controls. If the Developer tab is not visible, enable it through File > Options > Customize Ribbon.

Solution 1Recommended

Reset the ActiveX Control's Top Property

Use this method when a control stops responding or shifts after rows are hidden and shown.

Hiding rows can leave a control's actual position far down the worksheet, even when it appears to be in the right place. The Top property specifies its vertical position in points.

1
Show the rows

Select the rows around the hidden area, right-click the row headings, and choose Unhide.

2
Enter Design Mode

On the Developer tab, select Design Mode so you can edit the ActiveX controls.

3
Open control properties

Right-click an affected control and select Properties. Find the Top property in the Properties window.

4
Correct the position

Set Top to the intended vertical position in points. If needed, inspect a correctly positioned nearby control's Top value as a reference, then repeat for other affected controls.

5
Test the controls

Close the Properties window, turn off Developer > Design Mode, and click or edit each affected control to check its position and response.

Reset the ActiveX Control's Top Property
If the issue continues: For further troubleshooting, replace sensitive information with dummy data before sharing a zipped copy of the workbook with someone you trust.
Free Microsoft Office alternative

Work With Spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets and migrating everyday Office files. It does not fix Excel's ActiveX issue; test any workbook that relies on ActiveX controls or macros before switching.

Open and edit spreadsheets with a familiar ribbon-style interfaceCompatible with common Microsoft Excel formats, including XLSXUse WPS Spreadsheets for everyday worksheet editing and row managementFree and lightweight for routine Office tasks
microsoft office alternative - wps office

Frequently Asked Questions

Why does an ActiveX control stop working after I unhide rows?

Its actual position may have shifted far down the worksheet. On the Developer tab, turn on Design Mode, right-click the control, and check its Top property.

How do I show the Developer tab in Excel?

Go to File > Options > Customize Ribbon, select Developer, and confirm the change.

Why can't I click the control after changing its properties?

Check whether Developer > Design Mode is still enabled. Turn it off before testing the control.

Can WPS Office fix Excel's ActiveX control positioning?

No. Reset the control's Top property in Excel. WPS Office can be used as an alternative for everyday spreadsheets, but workbooks that depend on ActiveX controls or macros should be tested for compatibility.