Microsoft Excel Interview Question:

Is there a way to allow the use of AutoFilter on a protected worksheet?

Submitted by: Administrator

This needs a macro to run first:

Sub Protect_keep_filter()
With ActiveSheet
.EnableAutoFilter = True
.Protect DrawingObjects:=True, _
contents:=True, Scenarios:=True, _
UserInterfaceOnly:=True
End With
End Sub
Submitted by: Administrator