VBA & Macro Problems

How to Fix Excel ActiveX Controls Not Working

Huda Qurayshi Oct 9, 2026 869 views

Question details

The user needs to fix an Excel workbook where ActiveX controls, such as buttons and UserForms, are no longer clickable or functioning properly.

How to Troubleshoot Excel ActiveX Controls That Stopped Working

Product: Microsoft Excel
Device & OS: not provided
Scenario: Using an Excel application that relies on ActiveX controls and VBA macros for interactivity.
Observed behavior: ActiveX controls become unclickable, Workbook_Open events trigger errors, and Excel may crash, even though the same workbook functions correctly for other users.

Before you start

Ensure your workbook is saved as a Macro-Enabled Workbook (.xlsm) and create a backup copy before modifying ActiveX security settings or repairing your Office installation.

Solution 1Recommended

Adjust ActiveX Trust Center Settings

ActiveX controls may be disabled by default due to strict Trust Center security settings in Excel, preventing them from being clicked or executed.

Microsoft Excel often restricts ActiveX controls to protect your computer from potentially malicious code. If these settings are too restrictive, completely safe buttons and UserForms will become unclickable and act like static images.

Open Excel Options

Click on the 'File' tab in the top-left corner of Excel, then select 'Options' at the bottom of the menu.

Navigate to Trust Center

In the Excel Options dialog box, click on 'Trust Center' on the left pane, then click the 'Trust Center Settings...' button on the right.

Modify ActiveX Settings

Select 'ActiveX Settings' from the left menu. Choose 'Prompt me before enabling all controls with minimal restrictions' or, if you fully trust the document, select 'Enable all controls without restrictions and without prompting'.

Save and Restart

Click 'OK' to save your changes, completely close Microsoft Excel, and reopen your workbook to test the ActiveX controls.

Security Warning: Only enable all ActiveX controls if you completely trust the source of the macro-enabled workbook, as malicious scripts can harm your computer.

Solution 2

Delete Cached ActiveX '.exd' Files

Corrupted temporary ActiveX files created by Excel can cause controls to become unresponsive or trigger Workbook_Open errors.

Solution 3

Repair the Microsoft Office Installation

A corrupted local Excel installation or a failed background update can break the underlying components required for ActiveX to run.

Free Microsoft Office alternative

Try WPS Office for a Stable and Seamless Spreadsheet Experience

Tired of dealing with broken ActiveX controls, buggy updates, and frustrating crashes in Microsoft Excel? WPS Office provides a lightweight, highly compatible alternative with excellent VBA macro support, allowing you to run your automated tasks without the heavy overhead and frequent glitches.

1. Download and Install WPS Office: Visit the official WPS Office website and download the free installer for your operating system.
2. Open Your Macro-Enabled Workbook: Launch WPS Spreadsheet, go to 'Menu' > 'Open', and select your existing .xlsm file.
3. Enable Macros and Run: Click 'Enable Macros' if prompted by the security warning, and seamlessly interact with your automated workflows.

Completely free and lightweight Office suiteHigh compatibility with Microsoft Excel formats (.xlsx, .xlsm, .xls)Built-in robust VBA editor for seamless macro executionFamiliar user interface ensuring zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why are my Excel ActiveX buttons suddenly unclickable?

This is typically caused by a recent Microsoft Office or Windows update that corrupts the cached ActiveX (.exd) files on your computer, or by Excel's Trust Center resetting your security settings to disable ActiveX controls.

What is the difference between Form Controls and ActiveX Controls in Excel?

Form Controls are built directly into Excel and are simpler, more stable, and compatible across different platforms (including Mac). ActiveX Controls are older Windows-based components that offer more customization and event triggers but are prone to security blocks, update bugs, and compatibility issues.

Can I use Excel ActiveX controls on a Mac?

No, ActiveX is a proprietary Windows technology. ActiveX controls will not work on Microsoft Excel for Mac. If you need cross-platform compatibility, you should replace your ActiveX controls with standard Form Controls.

Will pausing OneDrive sync fix ActiveX errors?

Sometimes. If your macro-enabled workbook is stored on OneDrive, real-time synchronization or co-authoring locks can occasionally interfere with the VBA code's ability to interact with ActiveX objects. Pausing sync or moving the file to a local drive can help diagnose this issue.

Excel & Data Problems