'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel for Mac Error 400 When Importing UserForms (.frm and .frx)
Question details
The user is experiencing an Error 400 when attempting to run a UserForm in Excel for Mac because the application fails to import the associated .frx file containing graphics and layout data.
- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Importing a UserForm exported from Excel for Windows into the Excel for Mac VBA Editor.
- Observed behavior
- Excel for Mac successfully imports the .frm file but ignores the .frx file, resulting in missing graphics and an Error 400 when the UserForm is executed.
Ensure that both your .frm and .frx files are saved in the exact same folder location before attempting the import, as the .frm file relies on the relative path to locate its corresponding graphical data.
Import the UserForm Manually via the VBA Editor
Attempt a clean import of the UserForm files directly into the Visual Basic Editor (VBE). In some cases, the .frm file contains enough embedded data to restore basic elements.
While Mac Excel often struggles with binary .frx files created in Windows, executing a manual import through the Visual Basic Editor is the standard method to bring the code and layout into your Mac workbook.
Launch Excel for Mac, open your workbook, and press 'Option + F11' to open the Visual Basic Editor.
Go to the top menu and select 'File' > 'Import File...'.
Navigate to the folder containing your UserForm files. Select the .frm file (the .frx file will not be selectable but must be in the same folder) and click 'Open'.
Locate the imported UserForm in the Project Explorer, double-click it to view the layout, and press 'F5' to run it and check if Error 400 persists.
Re-create Complex Graphical Elements on Mac
Bypass the .frx file limitation by deleting broken image controls and re-inserting the graphics natively on your Mac.
Isolate the Issue in a Sample Workbook
Create a stripped-down version of your workbook to isolate which specific control or line of code is triggering Error 400 on the Mac.
Try WPS Office for Seamless Spreadsheet Management
If cross-platform VBA errors and missing UserForm graphics are disrupting your workflow, consider switching to WPS Office. It provides a lightweight, highly compatible alternative to Microsoft Office, ensuring your data and standard macros work smoothly across different devices.
- 1. Download the Installer: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install WPS Office: Run the downloaded installer and follow the simple on-screen instructions to set up the software.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets and seamlessly open your existing .xlsx or .xlsm files without worrying about format conversion.
Frequently Asked Questions
What is the difference between an .frm and an .frx file in Excel?
The .frm file is a plain text file that contains the structural code and properties of your UserForm. The .frx file is a binary file that stores graphical elements like embedded images, custom icons, and specific layout data associated with that form.
Why do I get Error 400 when running a macro in Excel for Mac?
Error 400 is a generic VBA error indicating a failure during macro execution. On a Mac, this frequently occurs when a UserForm tries to load incompatible Windows-specific objects, missing references, or graphical elements from an .frx file that macOS cannot properly process.
Can I open Excel Windows UserForms on a Mac without errors?
Basic UserForms without complex graphical elements usually transfer perfectly. However, forms containing custom Windows controls, heavy embedded images (.frx dependencies), or Windows API calls often require manual adjustments in the Mac VBA Editor.
How can I transfer a UserForm without losing images?
Ensure both the .frm and .frx files are exported into the exact same folder on the source machine. If transferring to a Mac still fails, the most reliable workaround is to remove the images in the Windows environment, import the plain form on your Mac, and manually re-add the images natively using the Mac VBA Editor.
