PrintTitles Property

Microsoft Excel Visual Basic

PrintTitles Property

       

True if the print titles for the worksheet are set based on the PivotTable report. 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. False if the print titles for the worksheet are used. The default value is False. Read/write Boolean.

Remarks

The PivotTable report must be the only one in the print area. To set an indented format for a PivotTable report, use the Format method.

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