Pivot Chart and EnableItemSelection
 

Hi,

I am using an Excel XP Pivot Table and associated Pivot Chart (connected to
an OLAP datasource)

I am also using PivotTable.EnableItemSelection=False to restrict users from
directly selecting from a dimension in the pivot table. This selection is
reflected in the pivot chart by the dropdown arrow being removed from the
said dimension, but I am still able to click on the Pivot Chart dimension
and select from the pop up selection menu that appears.

I need the dimension on the pivot table, and I would like to retain the
buttons on the pivot chart (i.e. objChart.HasPivotFields = True)

I just want to stop selection from this dimension from either the pivot
table or the pivot chart.

Can it be done?

Thanks in advance

Tony