Fix Missing UserForm Toolbox and Properties Window in Excel for Mac
Question details
The user needs to edit an Excel UserForm after its Toolbox and Properties window disappear.

- 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.
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.
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.
Open the macro-enabled workbook in desktop Excel for Windows.
Press Alt+F11, then locate the UserForm in the Project Explorer. If Project Explorer is hidden, select View > Project Explorer.
Select the UserForm and choose View > Object. If the Toolbox is hidden, select View > Toolbox; select View > Properties Window to show the properties.
Save the workbook in its macro-enabled format, reopen it in Excel for Mac, and run the form to check its behavior.

Send Microsoft feedback about Mac UserForm editing
Request or check support for the missing design interface in Excel for Mac.
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.

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.




