Skip to content

Latest commit

 

History

History
54 lines (32 loc) · 1.28 KB

Excel.Application.PrintCommunication.md

File metadata and controls

54 lines (32 loc) · 1.28 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Application.PrintCommunication property (Excel)
vbaxl10.chm133323
vbaxl10.chm133323
Excel.Application.PrintCommunication
8b8ad1c5-1999-d733-44f4-734b7a388986
04/05/2019
medium

Application.PrintCommunication property (Excel)

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

[!includeSupport and feedback]