Hello,
I have a pivot table where I analyze supplier performance. I have the
supplier name in the Page field. How can I determine in VBA the list of
suppliers contained in the field? I want to be able to give a person a drop
down box with a list of suppliers where they can pick the supplier name. I
know they are listed in the page field but I am putting the pivot table on a
hidden, protected sheet so they can't change it.

Thanks,

Bill