| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding a pivotfield using code
Using VBA code, how would I hide the pivotfield by the
name of "Test" which located in the Data section of the pivot table? Set PvtTable = Worksheets("Reps Current").PivotTables ("PivotTable1") For Each pvtfield In PvtTable.DataFields pvtfield.Orientation = xlHidden Next pvtfield Thank you Todd Huttenstine |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hiding a pivotfield using code
Remove it from the data section.
-- Regards, Tom Ogilvy "Todd Huttenstine" wrote in message ... Using VBA code, how would I hide the pivotfield by the name of "Test" which located in the Data section of the pivot table? Set PvtTable = Worksheets("Reps Current").PivotTables ("PivotTable1") For Each pvtfield In PvtTable.DataFields pvtfield.Orientation = xlHidden Next pvtfield Thank you Todd Huttenstine |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to change the PivotField to sum | Excel Discussion (Misc queries) | |||
| Hiding Code | Excel Discussion (Misc queries) | |||
| PivotTable, Pivotfield selective invisible, too slow | Excel Programming | |||
| Hiding VBA code | Excel Programming | |||
| Code for Grouping Text Values in Pivotfield | Excel Programming | |||
Hybrid Mode
