salesprod
asked on
Excel Pivot Table: Hide Drop-Down Arrow button from all pivot fields
Hello,
I'd like to hide Drop-Down Arrow button from all pivot fields so it resembles a regular table. Can that be done in VBA?
Thanks in advance,
I'd like to hide Drop-Down Arrow button from all pivot fields so it resembles a regular table. Can that be done in VBA?
Thanks in advance,
ASKER
Thanks for the quick reply Kevin, I really need to have the controls disabled because I am dealing with a large number of pivot tables (at least 16), one table per tab. Believe this will add more complexity and replicated tables?
Rgds,
Rgds,
Yes, it will. But you may not have any other choice. By default a pivot table implies user control over how the data is displayed and hence the drop down menu controls. If you were somehow able to prevent those controls from displaying then it wouldn't be a pivot table.
Kevin
Kevin
ASKER
I do understand the dynamic nature of pivots and cubes, I thank you for your input. Will wait till someone shows me how to hide the drop-down controls.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ohhhhh YEAH!!
That's exactly what I was talking about - Thank you so much. You rock!
:)
That's exactly what I was talking about - Thank you so much. You rock!
:)
Dim PivotTable As PivotTable
Set PivotTable = Sheets("Sheet1").PivotTabl
PivotTable.TableRange1.Cop
Sheets("Sheet2").[A1].Past
You can run this code everytime the pivot table changes.
Kevin