A book that will show you exactly what you are asking is: Excel 2002 Power
Programming with VBA by John Walkenbach. It is EXCELLENT......
"John Thomas" wrote in message
...
Hi all,

I have a pivot table that shows Project information like this:

Project Plan
------- -----
ProjectA $200
ProjectB $300
ProjectC $500

Is it possible to filter the pivot table to just 'ProjectB' while opening
the excel spreadsheet. The project that needs to be shown (in this case)
should
be a parameter to the spreadsheet. If the parameter is 'ProjectB' then the
pivot table would show:

Project Plan
------- -----
ProjectB $300


Any good books on programming pivot tables / charts?

Thanks,
John