VBA & Macro Problems

Fix Excel ActiveX Controls That Do Not Work on Mac

Natalie TaylorNatalie Taylor Nov 13, 2026 870 views

Question details

The user needs worksheet controls to work when opening an Excel workbook on a Mac.

Fix Excel ActiveX Controls That Do Not Work on 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.
Before you start

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.

Solution 1Recommended

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.

1
Show the Developer tab

In Excel for Mac, open Excel > Preferences > Ribbon & Toolbar, select Developer under the main tabs, and save the change.

2
Insert a Form Control

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.

3
Connect and test the 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.

4
Remove the old control

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.

Replace ActiveX Controls with Excel Form Controls
VBA may need changes: Code written for an ActiveX control may not work with a Form Control without modification. Use Developer > Record Macro to help generate VBA for supported worksheet actions, then test the resulting macro on Mac.
Free Microsoft Office alternative

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.

Open and edit common Microsoft Excel formats, including .xlsx and .xls.Work with worksheet data even when an Excel ActiveX control is not needed.Use a familiar spreadsheet interface for everyday editing.Move common office documents between WPS Office and Microsoft Office.
microsoft office alternative - wps office

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.