About Us

RADO[_3_]

I am using Excel 2002, and it shows pull-down buttons for pivot table
fields. Is there any way to hide them?

Thanks -
RADO

Debra Dalgleish

You can disable selection through code:

Sub DisableSelection()
Dim pt As PivotTable
Dim pf As PivotField
Set pt = ActiveSheet.PivotTables(1)
For Each pf In pt.PivotFields
pf.EnableItemSelection = False
Next
End Sub

RADO wrote:
I am using Excel 2002, and it shows pull-down buttons for pivot table
fields. Is there any way to hide them?

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

RADO[_3_]

Debra,

millions of thanks !!
Works beautifully. I much appreciate your time and expertise!

Best -
RADO

"Debra Dalgleish" wrote in message
...
You can disable selection through code:

Sub DisableSelection()
Dim pt As PivotTable
Dim pf As PivotField
Set pt = ActiveSheet.PivotTables(1)
For Each pf In pt.PivotFields
pf.EnableItemSelection = False
Next
End Sub

RADO wrote:
I am using Excel 2002, and it shows pull-down buttons for pivot table
fields. Is there any way to hide them?

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

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel pivot tables - specific expand/collapse buttons visibility	MichaÅ‚ Lenartowicz	Excel Discussion (Misc queries)	1	October 19th 09 09:48 AM
Pivot Tables - Top 10 hide negatives values	Cinny	Excel Discussion (Misc queries)	0	May 6th 09 05:08 AM
Can i hide parts of a Pivot tables subtotals???	alan82	Excel Discussion (Misc queries)	2	January 2nd 09 08:54 AM
pivot chart is it possible to hide individual field buttons? Layout Field buttons	Matt	Charts and Charting in Excel	0	August 27th 06 02:57 PM
Pivot Chart - how to hide buttons?	RADO[_3_]	Excel Programming	2	November 1st 03 09:22 AM

Menu

About Us