Office for Mac Issues

Fix Excel for Mac Crashes When VBA Uses PrintOut

Muhammad TalhaMuhammad Talha Nov 22, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

Update Excel for Mac and retest the macro

Check for available updates first, as the crash may be related to an Excel product defect.

1
Check for updates

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.

2
Retest printing

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.

Update Excel for Mac and retest the macro
Update availability: Office 2016 for Mac is out of support, so current updates may not be available for that version. Consider a supported Excel version if the issue persists.
Free Microsoft Office alternative

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.

Print worksheets manually without relying on the Excel PrintOut macroOpen and work with common Microsoft Excel formats, including XLS and XLSXUse a familiar spreadsheet interface for everyday tasksMove compatible spreadsheet files between Office applications
microsoft office alternative - wps office

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.