Pivot T Problem w/Expand-Collapse all PTs

**catnam** · 10-21-2014, 10:35 PM

I have some code in my workbook that I'm trying to get to expand and collapse all 3 pivot tables (#2,7,9) while worksheet is protected.
But it only expands the first pivot table and gives me a error code 400. I need the code it to expand and collapse all three PT, when the worksheet is protected. Thanks for your help.

**watersev** · 10-22-2014, 04:27 AM

hi catnam,

Please Login or Register  to view this content.

**catnam** · 10-22-2014, 08:46 AM

Sha Zam! This works great! I also needed to collapse all PT, so all I had to do was change .ShowDetail=1 to .ShowDetail=0. I really appreciate your help. For those with similar issue, also see my 10/20/14 post ( Pivot Table Problem with OFFSET for Dynamic Source).