Excel 2007: Code to allow auto filter in protected sheet

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:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
If Not Sheets("Jobs 1000+").ProtectContents Then
Sheets("Jobs 1000+").Protect
End If
If Not Sheets("Jobs 913-999").ProtectContents Then
Sheets("Jobs 913-999").Protect
ActiveWorkbook.Save
End If
End Sub

Any help would be greatly appreciated.