Set pivot table options using VBA

This specifially relates to the 'Show Values Row' in 2010, but even if I could get a general example of how to set pivot table settings (the ones that are in the 'options' dialog after you right click, then I could probably figure it out from there.

Help! I have a problem I'm hoping you can help me solve with VBA.

I built pivot tables in 2010. Well, there is a checkbox in 2010 ONLY that is unchecked by default. It is called 'show values row'. In stupid 2007, this row is shown by default and there is no way to remove it!

Do you know how I could create a macro to loop through all the pivot tables and check the 'Show Values Row' option?

This idiotic 'innovation' has broken my VBA pivot macros and formulas that reference pivots when used in 2007.

Oh and, by the way, this is only a "minor loss of fidelity". NOT!