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

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

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