Excel 2007 : Excel 2007: Protecting sheet on exit with VBA, whilst allowing autofilter

I have a code which protects the sheets on exit (see below). I need help creating a code that will protect the sheets, whilst allowing autofilter.

Hours of searching forums have returned results, none of which seem to be effective. Microsoft help site was no good either, as their solution is for excel 2000 only.
So far i have:

Please Login or Register  to view this content.

Any help would be greatly appreciated.