Donkey:
Thanks for the reply. Yes I'm using Excel 2007.
That's kind of what I was hoping for, but I hadn't been able to successfullly identify them in the object model yet. The following doesn't show any filters active:
?sheets("project Summary").pivottables(1).activefilters.count
0
...and this gives me an error...
?sheets("project Summary").pivottables(1).pivotfilters.count
This worked though...
?sheets("project Summary").pivottables(1).pivotfields(3).pivotitems(2).visible
True
Thanks for the link, that pointed me in the right direction!
Shred
Bookmarks