Microsoft Excel Question: Download Questions PDF
Is there a way to allow the use of AutoFilter on a protected worksheet?
Answer:
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
Sub Protect_keep_filter()
With ActiveSheet
.EnableAutoFilter = True
.Protect DrawingObjects:=True, _
contents:=True, Scenarios:=True, _
UserInterfaceOnly:=True
End With
End Sub
Download MS Excel Interview Questions And Answers
PDF