Fix Excel ActiveX Controls After Hiding and Showing Rows
Question details
Restore Excel ActiveX controls that stop responding or appear in the wrong position after worksheet rows are hidden and shown.

- 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.
Show the affected rows before checking the controls. If the Developer tab is not visible, enable it through File > Options > Customize Ribbon.
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.
Select the rows around the hidden area, right-click the row headings, and choose Unhide.
On the Developer tab, select Design Mode so you can edit the ActiveX controls.
Right-click an affected control and select Properties. Find the Top property in the Properties window.
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.
Close the Properties window, turn off Developer > Design Mode, and click or edit each affected control to check its position and response.

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.

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.




