PivotTable.ShowTableStyleColumnHeaders (Excel)

The ShowTableStyleColumnHeaders property is set to True if the column headers should be displayed in the PivotTable.

ActiveCell.PivotTable.ShowTableStyleColumnHeaders = True