How to hide filter buttons in pivot tables?
I am using Excel 2002, and it shows pull-down buttons for pivot table
fields. Is there any way to hide them? Thanks - RADO |
How to hide filter buttons in pivot tables?
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 |
How to hide filter buttons in pivot tables?
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 |
All times are GMT +1. The time now is 09:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com