| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - How VBA to "Show All".Visable = True
Using 2003
The code below does not work because "Show All" is not a valid PivotItems property class for the PivotField class. With ActiveSheet.PivotTables("PivotTable1") _ .PivotFields("Split") .PivotItems("Show All").Visible = False .PivotItems("1200-01 · Prescription").Visible = True End With How can I VBA-code my desire to "Show All".Visable = True (or False)? TIA Dennis |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table "Show all data" query | Excel Discussion (Misc queries) | |||
| Linking to a pivot table from a formatted invoice | Links and Linking in Excel | |||
| Change Data In Pivot Table | New Users to Excel | |||
| Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
| I am having trouble keeping numbers formatted in a Pivot Table | Excel Discussion (Misc queries) | |||
Threaded Mode
