Muokkaa

Jaa

Application.PrintCommunication property (Excel)

  • Artikkeli

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

Syntax

expression.PrintCommunication

expression A variable that returns an Application object.

Return value

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

Remarks

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.

Example

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.