View Full Version : Solved: how to hide drop-down list of pivot tables
Hello,
Do you know if it's possible to hide the drop-down lists of the fields used in a pivot table of Excel. In other words how do you hide the arrows of the listboxes of a pivot table?
thanx
matthewspatrick
01-09-2006, 04:25 PM
ALe,
I do not think you can do that, except by gimmicky tricks like dropping drawing shapes on top of the cells with the PivotFields.
Patrick
Ken Puls
01-09-2006, 05:17 PM
If I understood right, you can lock them...
Dim fld As PivotField
With ActiveSheet
For Each fld In .PivotTables("PivotTable1").PivotFields
fld.EnableItemSelection = False
Next fld
End With
thanks. It works fine. When you lock the list, you hide the arrow. The best would be to hide the arrow without locking the list. Is it possible?
Ken Puls
01-10-2006, 09:22 AM
Sorry, ALe, I don't know. I actually dug through the object browser to find that property. You might want to give that a shot, unless anyone else has an idea.
In the VBE, press F2 to bring it up. I searched for "Pivot" and ended up digging through the properties and methods of the Pivot Fields section as it seemed the most logical place.
I did the same. I couldn't find a property to do that.
Ken Puls
01-10-2006, 10:22 AM
One of us should just claim that it can't be done. Usually as soon as someone says that, someone comes along with a way. :rotlaugh:
austenr
01-10-2006, 10:48 AM
OK.. It can't be done...:rotlaugh:
IT CAN BE DONE!!!!!!!!!:clap: :clap: :clap:
I'm joking...sorry.
I searched a bit in internet but nobody has published any way.
Right, I'm going to mark this thread as solved... hoping someone will solve it in the future.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.