Hide all field buttons on pivot chart VBA

[Av8tordude]

I tried this code but creates an error. i want to hide all field buttons on a pivot chart.

Wks.ChartObjects(1).ShowAllFieldButtons = False

 

[Av8tordude]

bump

 

[RoryA]

You need the chart not the chartobject:

Wks.ChartObjects(1).Chart.ShowAllFieldButtons = False

 

[Av8tordude]

Thank you Rory for the helpful information and assistance....That solve it