Diable field list in pivot table

**ZuneidDassu** · 03-12-2014, 08:36 AM

Hi

Does anyone know some VBA code to diable field list in pivot table.

Thanks

**Izandol** · 03-12-2014, 08:39 AM

PivotTable class has EnableFieldList property. For example, you may use:

Please Login or Register  to view this content.

**ZuneidDassu** · 03-12-2014, 08:43 AM

Thankyou worked like a treat

**Izandol** · 03-12-2014, 08:44 AM

You are welcome.

Please remember to select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Re: Diable field list in pivot table