Table Autofilters - Disable specific columns

[hmltnangel]

Hi folks, hope you can help.

I have a Workbook that is controlled by a fair chunk of VBA. However, I have hd someone ask if I can switch on the autofilters, to allow them to sort/filter some of the columns after the VBA has ran.

Problem is, the VBA runs an autofilter currently to only display certain data, so I would like to disable the columns that the VBA already autofilters.

For example, VBA autofilters "Line Manager" in the table. Then displays everyone under that Line Manager. Is there a way to enable the autofilters for the rest of the columns, but block the users from changing the filter already applied in "Line Manager"?

 

[Jeffrey Mahoney]

Seems to me you are trying send out different versions of the table for specific Line Managers. Are you trying to hide subordinates that don't belong to Line Managers?

I don't know of a way to freeze the filter for one field. The best way is to separate your subordinates by Line Manager on different sheets, then they can't view subordinates from other managers.