Edit

Share via

PivotTable.PrintTitles property (Excel)

  • Article

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

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.