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