Export (0) Print
Expand All
Expand Minimize

Application.PrintCommunication Property (Excel)

Specifies whether communication with the printer is turned on. Boolean Read/write

Version Added: Excel 2010

expression .PrintCommunication

expression A variable that returns an Application object.

Return Value

True, if communication with the printer is turned on; otherwise False.

Set the PrintCommunication property to False to speed up the execution of code that sets PageSetup properties. Set the PrintCommunication property to True after setting properties to commit all cached PageSetup commands.

The following example suspends communication with the printer while setting PageSetup properties.

Application.PrintCommunication = False 
 With ActiveSheet.PageSetup 
 .PrintTitleRows = "" 
 .PrintTitleColumns = "" 
 End With 
Application.PrintCommunication = True
Show:
© 2014 Microsoft