Fix Excel for Mac Crashes When VBA Uses PrintOut
Question details
The user needs to stop Excel for Mac from crashing when a VBA macro calls the PrintOut method.
- Product
- Microsoft Excel 2016 for Mac
- Device & OS
- macOS
- Scenario
- A VBA macro prints workbooks or worksheets, particularly when processing multiple files or sheets.
- Observed behavior
- Excel may crash without an error message when the macro calls PrintOut.
Note your Excel version under Excel > About Excel and identify which workbook or worksheet triggers the crash. Check which printer is set as the default before testing a different one.
Update Excel for Mac and retest the macro
Check for available updates first, as the crash may be related to an Excel product defect.
In Excel, choose Help > Check for Updates and install any available Microsoft Office updates. If you installed Excel through the Mac App Store, check the App Store's Updates section instead.
Reopen the workbook and run the macro that calls PrintOut. If possible, first test one workbook or worksheet, then repeat the original multi-file or multi-sheet operation.

Change the default printer and test again
Use another printer to check whether the crash is related to the printer configuration or driver.
Report the crash to Microsoft
Report the issue if Excel still crashes after you check for updates and try another printer.
Print spreadsheets with WPS Office as an Excel alternative
WPS Office is a free, lightweight Office alternative with a familiar interface for opening and printing spreadsheets. Its support for common Excel formats makes it easier to move everyday files between applications. It does not fix Excel's VBA PrintOut crash, and VBA macro compatibility may vary.

Frequently Asked Questions
Why does Excel crash when a VBA macro calls PrintOut?
The crash may be caused by an Excel defect or a printer configuration or driver issue. Check for available updates, then test the same macro with another default printer.
How do I check my Excel for Mac version?
In Excel, choose Excel > About Excel to see the installed version. Include that version when reporting the crash.
How can I tell whether the printer is involved?
Set another available printer as the default in macOS Printers & Scanners, reopen Excel, and run the macro again. If the crash stops, check the original printer's driver and configuration.
Can WPS Office fix the Excel VBA crash?
No. WPS Office is an alternative for working with and manually printing compatible spreadsheets; it does not repair Excel, and VBA macro compatibility may vary.




