Hiding a pivotfield using code

[Todd Huttenstine]

Using VBA code, how would I hide the pivotfield by the
name of "Test" which located in the Data section of the
pivot table?


Set PvtTable = Worksheets("Reps Current").PivotTables
("PivotTable1")
For Each pvtfield In PvtTable.DataFields
pvtfield.Orientation = xlHidden
Next pvtfield

Thank you
Todd Huttenstine

 

[Tom Ogilvy]

Remove it from the data section.