Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm about to go crazy here. I'm attempting to hide (change the orientation)
of a field in a pivot table. I recorded the step of removing a data field from the pivot table. The following is the code: ActiveSheet.PivotTables("Contractural_NCLs_US").Pi votFields("NCO_w_INIT").Orientation = xlHidden The recorded code does not work. I keep getting the error msg: Unable to set the Orientation property of the PivotField class. Amazing that even the recorded VBA code doesn't work. The pivot table name & pivot field names are correct. This has got me stumped. Help, please. Thanks, David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
turn off pivotfield sort | Excel Programming | |||
PivotField refreshment | Excel Programming | |||
PivotField AfterUpdate event? | Excel Programming | |||
PivotField select all | Excel Programming | |||
Hiding a pivotfield using code | Excel Programming |