Posted to microsoft.public.excel.programming

LuisE

external usenet poster

Posts: 133

Pivot Items Visible

I'm trying to make all pivot items non visible and then mak only one visible
based on a cell value.

Dim pitem As PivotItem

Sheet3.PivotTables("TypesOfService").ManualUpdate = True

''''''Show all items
For Each pitem In
Sheet3.PivotTables("TypesOfService").PivotFields(" Type of service").PivotItems
pitem.Visible = False
Sheet3.PivotTables("TypesOfService").PivotFields(" Type of
service").PivotItems("(blank)").Visible = False
Next

Thanks in advance

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Hide all items in Pivot Field except specific items	VAMS	Excel Programming	1	June 19th 09 10:19 AM
Set Pivot-Table Visible Items	Mike H.	Excel Programming	1	July 25th 08 08:59 PM
Unable to access visible property of Pivot Items class	Geoff	Excel Programming	2	May 21st 07 03:00 AM
Unable to access visible property of Pivot Items class	Geoff	Excel Programming	0	May 20th 07 10:20 PM
PivotItems.Count is 0 when items are visible on the sheet	iD	Excel Programming	4	March 3rd 05 02:07 AM

All times are GMT +1. The time now is 02:13 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us