VBA & Macro Problems

How to Fix Excel ActiveX Controls Not Working for Some Users

Muhammad TalhaMuhammad Talha Nov 2, 2026 870 views

Question details

Users need to resolve an issue where ActiveX controls in a shared Excel macro workbook cannot be operated.

How to Fix Excel ActiveX Controls Not Working for Some Users
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.
Before you start

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.

Solution 1Recommended

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.

1
Close the workbook

Ensure the affected Excel file is completely closed on the user's computer.

2
Open File Properties

Right-click the downloaded Excel file in the Windows File Explorer and select Properties from the context menu.

3
Unblock the file

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.

4
Reopen the file

Launch the Excel file again and test the ActiveX controls to see if they are now clickable.

Unblock the Excel File in Windows Properties
Security Check: Only unblock files if you are absolutely certain they come from a trusted source and are safe to execute.
Free Microsoft Office alternative

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. 1. Download the software: Visit the official WPS website and download the free installation package for your operating system.
  2. 2. Install WPS Office: Run the installer and follow the quick on-screen instructions to set up the suite.
  3. 3. Open your files: Launch WPS Spreadsheet and open your existing files to continue your work without compatibility issues.
Highly compatible with Microsoft Excel (.xlsx, .xls, .xlsm) formatsLightweight design ensures fast opening of large and complex spreadsheetsFamiliar user interface requires zero learning curve for seamless migrationFree to download and use for your everyday office tasks
microsoft office alternative - wps office

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.