R RADO Nov 3, 2003 #1 I am using Excel 2002, and it shows pull-down buttons for pivot table fields. Is there any way to hide them? Thanks - RADO
I am using Excel 2002, and it shows pull-down buttons for pivot table fields. Is there any way to hide them? Thanks - RADO
D Debra Dalgleish Nov 3, 2003 #2 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
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
R RADO Nov 3, 2003 #3 Debra, millions of thanks !! Works beautifully. I much appreciate your time and expertise! Best - RADO
Debra, millions of thanks !! Works beautifully. I much appreciate your time and expertise! Best - RADO
