PivotField.EnableItemSelection (Excel)

When set to False, disables the ability to use the field dropdown in the user interface. The default value is True.

A run-time error occurs if the OLAP PivotTable field is not the highest level for the hierarchy.

ActiveCell.PivotField.EnableItemSelection = True