PrintAllSheets Property

Enable/Disable the flag that indicates whether to print all Excel worksheets or not.

Type

Boolean

Remarks

By default, only the active worksheet will be printed. Use this property if you need to print all worksheets.

Example Usage

Set oPrinter = CreateObject("easyPDF.Printer.7")

Set oPrintJob = oPrinter.ExcelPrintJob
oPrintJob.PrintAllSheets = True

oPrintJob.PrintOut "C:\input.xls", "C:\output.pdf"