PDA

View Full Version : Solved: how to hide drop-down list of pivot tables



ALe
01-09-2006, 07:38 AM
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

ALe
01-10-2006, 01:24 AM
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.

ALe
01-10-2006, 10:06 AM
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:

ALe
01-10-2006, 10:57 AM
IT CAN BE DONE!!!!!!!!!:clap: :clap: :clap:

I'm joking...sorry.
I searched a bit in internet but nobody has published any way.

ALe
01-10-2006, 11:00 AM
Right, I'm going to mark this thread as solved... hoping someone will solve it in the future.