PivotTable.Hidden (Excel)

Checks whether the PivotTable exists at the worksheet level.

When the Hidden property is set to True, the PivotTable object is hidden from the worksheet level. When the property is set to False, the PivotTable exists on a worksheet.

Dim booHidden As Boolean
booHidden = ActiveCell.PivotTable.Hidden