View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Anya Anya is offline
external usenet poster
 
Posts: 3
Default Problem changing pivot field

Try putting iCode.Value in this loop:

For Each iCode In PT.PivotFields("product_code").PivotItems
PT.PivotFields("product_code").PivotItem
(iCode.Value).Visible = False
Next iCode

-----Original Message-----
Hello-

I am trying to take selections from a ListBox (named

Product_Codes)
and use those selections in a pivot table. As a first

step I am
trying to deselect all items in a pivot field

called "product_code"
but I keep getting an error. Here is my code (sorry if

it posts
sloppy):

[vb]Private Sub Create_Report_Click()

Dim iCode As PivotItem
Dim PT As PivotTable

Set PT = Sheets("Network").PivotTables("PivotTable1")

Application.ScreenUpdating = False

' Clear all Product Codes from Pivot Field "product_code"

For Each iCode In PT.PivotFields

("product_code").PivotItems
PT.PivotFields("product_code").PivotItems

(iCode).Visible = False
'Gettin

g error
here;
Next iCode '"Unable to get PivotItems Property of

the
PivotField Class

Application.screendupdating = True

End Sub[/vb]

I know it is difficult without seeing the userform or

file, but any
help is appreciated. Thanks!
.