Hi All,

I have a pivot table where in the "Report filter" values are changed using VBA input. I don't want any of the user to change manually the report filter value from the drop down.

I want the user to have some flexibility on "Row labels" on the pivot, so that they can change the layout by drag and drop for the "Row labels". Due to this reason i can not protect the sheet.

Is there a way to lock "Report filter" using VBA in the pivot table.

Thanks in advance.

Nazim