Office for Mac Issues

Fix Missing UserForm Toolbox and Properties Window in Excel for Mac

Amos GikundaAmos Gikunda Nov 14, 2026 869 views

Question details

The user needs to edit an Excel UserForm after its Toolbox and Properties window disappear.

Excel for Mac UserForm Toolbox and Properties Window Are Missing
Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
A UserForm created in Excel for Mac is closed and reopened for editing.
Observed behavior
The form opens as a code window without the Toolbox or Properties window, although the form still runs and macros can be created.
Before you start

Check that the workbook is saved in a macro-enabled format such as .xlsm and that you have access to Excel for Windows if you need to edit the form. VBA UserForm design and editing was not officially supported in Excel for Mac in the versions described in this report.

Solution 1Recommended

Edit the UserForm in Excel for Windows

Use the Windows VBA editor to access the UserForm designer, Toolbox, and Properties window.

A form may still run on a Mac even when its design interface is unavailable. Editing it in Excel for Windows is a practical workaround, but test the workbook on the Mac afterward because platform compatibility can vary.

1
Open the workbook

Open the macro-enabled workbook in desktop Excel for Windows.

2
Open the VBA editor

Press Alt+F11, then locate the UserForm in the Project Explorer. If Project Explorer is hidden, select View > Project Explorer.

3
Open the form designer

Select the UserForm and choose View > Object. If the Toolbox is hidden, select View > Toolbox; select View > Properties Window to show the properties.

4
Save and test

Save the workbook in its macro-enabled format, reopen it in Excel for Mac, and run the form to check its behavior.

Edit the UserForm in Excel for Windows
Free Microsoft Office alternative

Work with Excel spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheets. Its Microsoft Office format compatibility can make moving everyday files easier, but it does not fix Excel for Mac's UserForm designer or guarantee VBA UserForm compatibility.

Open and edit everyday spreadsheets in a familiar interfaceCompatible with common Excel formats, including XLSXMove between Microsoft Office files and WPS Office for routine spreadsheet workUse a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does my UserForm open as code in Excel for Mac?

In the versions described in this report, VBA UserForm design and editing was not officially supported on Mac. The form can still run even when the visual designer, Toolbox, and Properties window are unavailable.

How do I show the Toolbox in Excel for Windows?

Press Alt+F11, select the UserForm in Project Explorer, and choose View > Object. In the designer, choose View > Toolbox if it is hidden.

Can I edit a UserForm on Windows and then use it on a Mac?

You can edit the form in desktop Excel for Windows, save the macro-enabled workbook, and test it in Excel for Mac. Some VBA features or controls may behave differently across platforms.

Should I install an older Excel for Mac version to restore the designer?

An older version may have shown the designer, but that behavior was not officially supported and is not a dependable fix. Older versions may also lack security updates; use Excel for Windows for form editing instead.