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

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
When I type a number, example 44, it becomes 0.44 even if I format the cell without decimals?How can I protect an Excel file (and associated code) from unauthorized copying and/or create time limited functionality?