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...

[vba] Dim fld As PivotField
With ActiveSheet
For Each fld In .PivotTables("PivotTable1").PivotFields
fld.EnableItemSelection = False
Next fld
End With[/vba]

**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.

**austenr** · 01-10-2006, 10:48 AM

OK.. It can't be done...

**ALe** · 01-10-2006, 10:57 AM

IT CAN BE DONE!!!!!!!!!

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.

Thread: Solved: how to hide drop-down list of pivot tables

Thread Tools

Display

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

Posting Permissions