Sheet protection with autofilter disabled

[nickmax1]

I have a workbook with many sheets to which I apply this sheet protection:

Please Login or Register  to view this content.

The primary goal of this was to stop people from being able to filter as it knackers my spreadsheet but also basic security so they cant delete coloms or do anything silly.

My problem is that though the code works very well, I have many other macros that rely on the autofilter to calculate things. can my code be amended to allow other macros to use the autofilter function?

Possibly I could have a warning message pop up if the row 16 were highlighted (as a workaround)?

[nickmax1]

i have managed to come up with a solution. I created another module that unlocked all sheets, and simply used the CALL command to unlock all sheets when a macro that relied upon autofilters needed them, and at the end of the macro call upon the "locking" macro above to disable autofilter again.