Fix Excel ActiveX Controls That Do Not Work on Mac
Question details
The user needs worksheet controls to work when opening an Excel workbook on a Mac.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- A workbook with ActiveX controls created in Excel for Windows is opened in Excel for Mac.
- Observed behavior
- ActiveX controls appear as simple shapes or do not function on the Mac.
Identify the ActiveX controls and any macros they use in the workbook. If the Developer tab is hidden, enable it in Excel's Ribbon & Toolbar preferences before adding replacement controls.
Replace ActiveX Controls with Excel Form Controls
Use Form Controls when worksheet buttons, checkboxes, or other controls need to work in Excel for Mac.
ActiveX controls are Windows-only. Form Controls are supported in Excel for Mac, but their appearance and available features may differ from the ActiveX controls they replace.
In Excel for Mac, open Excel > Preferences > Ribbon & Toolbar, select Developer under the main tabs, and save the change.
On the Developer tab, choose a suitable Form Control, such as a button or checkbox, and draw it on the worksheet near the ActiveX control.
Right-click the new control and use Format Control to set its options or linked cell. For a button that runs VBA, choose Assign Macro and select a suitable macro, then click the control to test it.
Once the replacement works, select the nonfunctional ActiveX object on the worksheet and delete it. Save the workbook as an Excel Macro-Enabled Workbook (.xlsm) if it contains macros.

Work with Excel Files in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Excel formats, making it easy to move everyday worksheet work between suites. It does not make Excel ActiveX controls work on Mac; test any macros or controls you need before switching.

Frequently Asked Questions
Why do ActiveX controls appear as shapes in Excel for Mac?
Excel ActiveX controls are supported on Windows, not Mac. Replace worksheet ActiveX controls with Form Controls from the Developer tab for Mac use.
How do I show the Developer tab in Excel for Mac?
Open Excel > Preferences > Ribbon & Toolbar, select Developer in the main tabs list, and save the change.
Will my ActiveX macro work with a Form Control?
Not necessarily. Right-click a Form Control button and choose Assign Macro to connect a macro, but code that refers to an ActiveX control may need to be rewritten and tested.
Can I create a VBA UserForm in Excel for Mac?
Excel for Mac does not support creating or editing VBA UserForms and their controls. Worksheet Form Controls are an alternative for suitable tasks.




