Posted to microsoft.public.excel.programming

headly

external usenet poster

Posts: 45

Pivot Table Pivot Item Visible - Why so difficult

A recorded macro does this code

With ActiveSheet.PivotTables("PivotTable1").PivotFields ("Product Name")
.PivotItems("Aniseed Syrup").Visible = True
End With

Yet when i try the comand in the immediate window i get run time error 1004
unable to set the visible property of the pivotitem class

Am i missing a reference? As i type pivot code, i don't get any code hints.
is this a late binding problem?

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
Pivot Table Calculated Item	Dominic	Excel Discussion (Misc queries)	1	April 26th 06 11:50 PM
Pivot Table Calculated Item	SamBayer1957	Excel Discussion (Misc queries)	1	August 11th 05 10:27 PM
pivot table data item	Dominique Feteau[_2_]	Excel Programming	4	December 18th 04 05:01 PM
Visible Property Pivot Item	anonymous	Excel Programming	0	September 23rd 04 01:41 PM
Difficult Pivot Table Technical Question	Heath[_2_]	Excel Programming	0	December 11th 03 05:18 PM

All times are GMT +1. The time now is 11:07 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us