determine if Pivot Table field item is hidden

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivot Table - Calculating Field/item	=?Utf-8?B?V0xNUGlsb3Q=?=	Microsoft Excel Programming	1	8th Oct 2006 04:06 PM
Sort Pivot Table using hidden data field	=?Utf-8?B?Z29vZnkxMQ==?=	Microsoft Excel Misc	4	3rd Feb 2006 08:13 PM
pivot table page field hidden items	marwan	Microsoft Excel Discussion	2	26th Dec 2004 06:06 AM
Pivot Table Field's Item Listbox	=?Utf-8?B?Z29yZG8=?=	Microsoft Excel Programming	3	29th Nov 2004 01:42 AM
determine cell is part of pivot item or pivot field	isskiran	Microsoft Excel Programming	3	8th Dec 2003 07:18 PM