Automate pivot table selection
 

XL 2003; Win XP

I've created a PT with one row field "Customer" which lists all my
customers. I want to click on the Customer drop-down, deselect "Show
All" and select several customers from the list.

I tried recording a macro to do this, but it didn't record the
selecting and deselecting.

Any ideas?

TIA

Steve