Skip to content

Latest commit

 

History

History
42 lines (24 loc) · 1.1 KB

Excel.PivotTable.PrintTitles.md

File metadata and controls

42 lines (24 loc) · 1.1 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
PivotTable.PrintTitles property (Excel)
vbaxl10.chm235131
vbaxl10.chm235131
Excel.PivotTable.PrintTitles
a8138146-bfe9-1af9-c101-0c095c4a91a5
05/09/2019
medium

PivotTable.PrintTitles property (Excel)

True if the print titles for the worksheet are set based on the PivotTable report. False if the print titles for the worksheet are used. The default value is False. Read/write Boolean.

Syntax

expression.PrintTitles

expression A variable that represents a PivotTable object.

Remarks

The row print titles are set to the rows that contain the PivotTable report's column field items. The column print titles are set to the columns that contain the row items.

Example

This example specifies that the print title set for the worksheet is printed when the fourth PivotTable report on the active worksheet is printed.

ActiveSheet.PivotTables("PivotTable4").PrintTitles = True

[!includeSupport and feedback]