PivotTable.PrintTitles (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.

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.

ActiveCell.PivotTable.PrintTitles = True