How to Fix Excel ActiveX Controls Not Working for Some Users
Question details
Users need to resolve an issue where ActiveX controls in a shared Excel macro workbook cannot be operated.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Sharing Excel macro workbooks containing form controls or ActiveX elements with other users via email or external network drives.
- Observed behavior
- The workbook opens normally, but users are unable to click or operate the embedded ActiveX controls, such as check boxes, option buttons, or command buttons.
Ensure the affected users have downloaded and saved the Excel file to their local hard drive rather than attempting to operate the controls directly from a read-only email attachment preview.
Unblock the Excel File in Windows Properties
Remove Windows security blocks on files downloaded from the internet or received via email, which prevents ActiveX controls from running.
Windows automatically blocks active content in files originating from another computer or the internet to protect your system. Unblocking the file is usually the fastest way to restore functionality.
Ensure the affected Excel file is completely closed on the user's computer.
Right-click the downloaded Excel file in the Windows File Explorer and select Properties from the context menu.
Navigate to the General tab. Look for a Security section at the bottom and check the box that says 'Unblock'. Click Apply, then click OK.
Launch the Excel file again and test the ActiveX controls to see if they are now clickable.

Adjust Excel Trust Center Settings for ActiveX
Modify Excel's internal security settings to ensure ActiveX controls are allowed to prompt the user or run.
Review Organizational IT Security Policies
Consult your IT department to check if enterprise group policies are strictly disabling macros and ActiveX controls.
Open and Manage Spreadsheets Seamlessly with WPS Office
If restrictive Microsoft Excel security policies are preventing your team from working efficiently, try WPS Office. It provides a lightweight, highly compatible, and user-friendly alternative for spreadsheet management without the heavy overhead of strict enterprise macro locks.
- 1. Download the software: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install WPS Office: Run the installer and follow the quick on-screen instructions to set up the suite.
- 3. Open your files: Launch WPS Spreadsheet and open your existing files to continue your work without compatibility issues.

Frequently Asked Questions
Why do ActiveX controls work on my computer but not for my colleagues?
This typically occurs because the file was transferred via email or downloaded from the internet, triggering a 'Mark of the Web' security block on the recipient's machine. It can also be caused by differing Trust Center settings or specific IT policies applied to their user account.
How can I share files without requiring users to unblock them?
You can avoid the block by placing the Excel file in a 'Trusted Location' configured in the users' Excel Trust Center, sharing the file via a secure internal network drive, or distributing it through trusted enterprise SharePoint libraries instead of email attachments.
What is the difference between Form Controls and ActiveX Controls in Excel?
Form controls are built directly into Excel, are simpler to use, and are less prone to security blocks. ActiveX controls offer more advanced formatting and rich VBA event triggers but are frequently restricted by organizational IT security policies due to their potential vulnerabilities.
Can IT policies permanently disable ActiveX in Excel?
Yes, system administrators can use Windows Group Policy (GPO) to force-disable VBA macros and ActiveX controls across all devices in an organization. When this happens, end-users will find the settings grayed out and cannot turn them on manually.




