Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I got the error
Unable to set the visible property of the PivotItem class. when i try to set a pivotitem to visible: Dim PF As PivotField Dim PFI As PivotItem For Each PF In PFs Set PFs = ActiveSheet.PivotTables("PivotTable2").PivotFields For Each PFI In PF.HiddenItems PFI.Visible = True Next PFI Next PF is there any solution, I have found yet no such (only at http://www.experts-exchange.com/msof..._20275761.html , but they wanted me to register first...) Thanks Holger |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA error: Unable to set the Values property of the Series class | Excel Programming | |||
Unable to set the NumberFormat Property of the Range Class - ERROR | Excel Programming | |||
Error: Unable to get the OLEObjects property of the worksheet class | Excel Programming | |||
Run-time error '1004' - Unable to set the Visible property of the Worksheet class | Excel Programming | |||
Unable to set the colorIndex Property of the Interior Class Error | Excel Programming |