PivotTable.AlternativeText (Excel)

Returns or sets the descriptive (alternative) text string for the specified PivotTable.

The value of the AlternativeText property corresponds to the value in the Title box on the Alt Text tab of the PivotTable Options dialog box.

ActiveCell.PivotTable.AlternativeText =