Office for Mac Issues

Fix the AppleScript Print Command for a Worksheet in Excel 2016 for Mac

Natalie TaylorNatalie Taylor Nov 20, 2026 868 views

Question details

Find the correct way to print the first worksheet in Excel 2016 using AppleScript or VBA.

Fix the AppleScript Print Command for a Worksheet in Excel 2016 for Mac
Product
Microsoft Excel 2016 for Mac
Device & OS
Mac
Scenario
The user wants to automate printing the first worksheet in an Excel workbook.
Observed behavior
The AppleScript command "print out sheet 1" may not match the syntax in Excel's AppleScript dictionary.
Before you start

Open the workbook in Excel and confirm that its first worksheet is the one you want to print. Check that a printer is available through File > Print.

Solution 1Recommended

Check Excel's AppleScript dictionary for the print command

Use this approach when your workflow requires AppleScript.

1
Open the scripting dictionary

Open Script Editor on your Mac, choose File > Open Dictionary, and select Microsoft Excel.

2
Find the print command

Search the Excel dictionary for "print" and review the command's target, parameters, and available print settings.

3
Revise and test the script

In Script Editor, replace "print out sheet 1" with the print command and worksheet reference documented for your Excel version. Compile the script, then run it against the open workbook.

Check Excel's AppleScript dictionary for the print command
Check available print settings: Excel's dictionary describes options such as copies, page range, target printer, and whether to show the print dialog. Use the syntax shown in your installed version.
Free Microsoft Office alternative

Print Excel Workbooks with WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar interface for opening and printing compatible Excel workbooks. It makes moving everyday spreadsheet work straightforward, but it does not fix Excel's AppleScript commands.

Open and print worksheets from a familiar spreadsheet interfaceCompatible with Microsoft Excel formats such as XLSXFree and lightweight for everyday office tasksA familiar layout helps users transition from Microsoft Office
microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't "print out sheet 1" work in AppleScript?

The phrase may not match Excel 2016's AppleScript syntax. In Script Editor, choose File > Open Dictionary, select Microsoft Excel, and check the documented print command and worksheet reference.

Can I print the first sheet without AppleScript?

Yes. In Excel's Visual Basic Editor, add a macro containing Sheets(1).PrintOut, then run it from Tools > Macro > Macros with the intended workbook active.

Where can I find AppleScript options for copies or a page range?

Open Microsoft Excel's dictionary through Script Editor > File > Open Dictionary. Search for the print command and review its parameters and related print settings.

Will WPS Office fix my Excel AppleScript command?

No. Excel's AppleScript command belongs to Microsoft Excel. WPS Office is an alternative for opening and printing compatible Excel workbooks, not a repair for Excel automation.