Making Visible on a Pivot table

[timely]

I am working on vba to setup a pivot table but only what values of certain things to show.

Currently I have:
With ActiveSheet.PivotTables("PivotTable4").PivotFields("Pkg")
.PivotItems("AUTO03F").Visible = False
.PivotItems("AUTO20F").Visible = False
.PivotItems("(blank)").Visible = False
End With

I know I can also make each item true. The problem is that I do not always know what all the Items will be I want to make it so that only certain items will be true without having to know what all the other items will be in the pivot table.

Any one know what I would use to first make all items visible false and then make only the ones I want to see true?

Thanks
Tim

 

[SkipVought]

Tim,

What? Is this a mindreading game? ;-)

The rules are, you MUST have at least ONE pivot item visible.

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}

 

[KenWright]

A good place to start:-

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

Regards
Ken..............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[timely]

Skip,

I did not explain very well. I know that one has to be showing and I want to have two certain ones show. I just do not know all the ones that will be needed to be hidden. So I was looking for a way to show what I want seen in the item list without having to know the other ones but I all except the two hidden.

Ken,

Thanks, I will see if I can integrate some of that to my goal.

Thanks,
Tim