PivotField.AutoShowType (Excel)

Returns the xlAutomatic constant if AutoShow is enabled for the specified PivotTable field; returns xlManual if AutoShow is disabled.

Dim lngAutoShowType As Long
lngAutoShowType = ActiveCell.PivotField.AutoShowType