| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
determine if Pivot Table field item is hidden
I have a field in a pivot table named "PC GROUP" with an item named "DSD". I
am wondering if there is a way to programmatically determine if DSD is currently a hidden (or visible) item. Thank you for your help. -- Rich |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
determine if Pivot Table field item is hidden
Rich,
Maybe check the Orientation property of the pivot filed. Try: Sub test() If ActiveSheet.PivotTables("PC GROUP").PivotFields("DSD").Orientation = xlHidden Then MsgBox "DSD field is hidden" End If End Sub -- Hope that helps. Vergel Adriano "badger_rich" wrote: I have a field in a pivot table named "PC GROUP" with an item named "DSD". I am wondering if there is a way to programmatically determine if DSD is currently a hidden (or visible) item. Thank you for your help. -- Rich |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
determine if Pivot Table field item is hidden
If ActiveSheet.PivotTables(1).PivotFields("PC GROUP") _
.PivotItems("DSD").Visible Then badger_rich wrote: I have a field in a pivot table named "PC GROUP" with an item named "DSD". I am wondering if there is a way to programmatically determine if DSD is currently a hidden (or visible) item. Thank you for your help. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table calculated field or item | Excel Worksheet Functions | |||
| pivot table calculated field or item | Excel Discussion (Misc queries) | |||
| Need Help Using Calculated Field or Item in Pivot Table | Excel Worksheet Functions | |||
| Pivot Table Calculated field item | Excel Discussion (Misc queries) | |||
| determine cell is part of pivot item or pivot field | Excel Programming | |||
Linear Mode
