HasPivotFields Property Example
This example disables the PivotChart controls on the Sales chart in the 1996 Report workbook.
Workbooks("1996 Report").Charts("Sales") _ .PivotLayout.HasPivotFields = False