Pivot Table Deselect all items

[Guest]

Hi

Is there a VBA command to deselect all items of RowField or ColumnField at
one rather than making the visible property of each item to false?

I have like 35 different items and it may vary and i only want 6 of them.

Thanks

 

[Debra Dalgleish]

There's sample code here for showing and hiding items:

http://www.contextures.com/xlPivot03.html

 

[Guest]

Thanks Debra.

There's sample code here for showing and hiding items:

http://www.contextures.com/xlPivot03.html