PivotItem.Visible
 

Hi all,

within a (Excel 2000) pivot table, I'd like to hide all items except of
one, which is named 'Total'.
The item list can change, so hiding item by item does not work.The
function could look like:

..PivotItem.Visible = False
..PivotItem("Total").Visible = True

I am looking for a function to hide all items at once. Any ides?

Best regards & thanks for help,
the Excelgeek


--
Excelgeek
------------------------------------------------------------------------
Excelgeek's Profile: http://www.excelforum.com/member.php...o&userid=24285
View this thread: http://www.excelforum.com/showthread...hreadid=378940

PivotItem.Visible
 

There's no "HideAll" method, but there's sample code here to loop
through the list and hide or show items:

http://www.contextures.com/xlPivot03.html

Excelgeek wrote:
Hi all,

within a (Excel 2000) pivot table, I'd like to hide all items except of
one, which is named 'Total'.
The item list can change, so hiding item by item does not work.The
function could look like:

PivotItem.Visible = False
PivotItem("Total").Visible = True

I am looking for a function to hide all items at once. Any ides?

Best regards & thanks for help,
the Excelgeek




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

PivotItem.Visible
 

Take a look at Debra Dalgleish's code:

http://www.contextures.com/xlPivot04.html
look for: Sub DeleteOldItemsWB()


She deletes items (instead of .visible = false), but that's easy to change.



Excelgeek wrote:

Hi all,

within a (Excel 2000) pivot table, I'd like to hide all items except of
one, which is named 'Total'.
The item list can change, so hiding item by item does not work.The
function could look like:

PivotItem.Visible = False
PivotItem("Total").Visible = True

I am looking for a function to hide all items at once. Any ides?

Best regards & thanks for help,
the Excelgeek

--
Excelgeek
------------------------------------------------------------------------
Excelgeek's Profile: http://www.excelforum.com/member.php...o&userid=24285
View this thread: http://www.excelforum.com/showthread...hreadid=378940

--

Dave Peterson