Hide a single pivot table?

[mcwillis81]

Hi All,

I've written a some code to hide charts and pivots the charts part works perfectly however as i have 12 pivots all feeding from the same source when i try and hide one of them using

"tablerange2.entirerow.hidden = true"

all of the pivot tables are hidden not just the one selected. I assume this is to do with them using the same cache but i'm stumped so any help would be greatly appreciated!

 

[Truiz]

Sub piv()

ActiveSheet.PivotTables(1).TableRange1.Hidden = True


End Sub

 

[mcwillis81]

Sub piv()

ActiveSheet.PivotTables(1).TableRange1.Hidden = True


End Sub

Thanks for your help however, this hasn't worked.

It comes up with a runtime error 1004

unable to set the hidden property of the range class

 

[Truiz]

Sorry I don't know what I was thinking

Sub piv()

ActiveSheet.PivotTables(1).TableRange1.EntireRow.Hidden = True




End Sub