Making all pivot items invisible before doing Do Loop

Hi there

Appreciate any help as I am building on from this post here
I have the below bit of code that I want to go through my pivot chart and make the last 7 days of data visible.

Here I am assuming that the date 07/09/2011 is the only date visible in the pivot chart. So when I run this macro the 12/09/2011 to the 18/09/2011 will also be visible in the pivot chart.

So when the below macro is finished I will end up with 07/09/2011, and 12/09/2011 to the 18/09/2011 all visible.

But what I want to do is make all dates invisible first and then go through my Do Loop making the the 12/09/2011 to the 18/09/2011 all visible.

Can anyone suggest hot the best way is of doing this?

Please Login or Register  to view this content.

Thanks