Pivot Table - VBA
 

I have a workbook into which I import dat from my Oracle database. I then
use VBA macros to create a pivot table and analyse the data. One of the
macros takes a drop down and deselects 7 of the 10 choices. I'd like to do
this differently i.e. I would like to deselect all the select the ones that I
want rather than have all selected and de-select the ones I don't want. Any
tips will be gratefully received.

Thanks

Alan