Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PivotItem positioning... | Excel Programming | |||
How to add a PivotItem ? | Excel Programming | |||
how to set pivotitem.visible property to true | Excel Programming | |||
How can I set PivotItem.Visible property to True? | Excel Programming | |||
Pivotitem count | Excel Programming |