autofilter in protected worksheet

K

Ki

Hi, can we use the autofilter function in a protected
worksheet? How can we do that? I found when I protect the
sheet, the autofilter box become inactive. The Office
version I use is Office 2000.
Hope someone can share with me! Thanks in advance!

Regards,
Ki
 
P

Paul B

Ki, you can do it with a macro, put in this wookbook code module, password
is set to pass

Private Sub Workbook_Open()
With Worksheets("sheet1")
.Protect Password:="pass", userinterfaceonly:=True
.EnableAutoFilter = True
End With

End Sub

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
H

Harald Staff

You're right Paul, assuming that Autofilter is already set up and activated.
It can't be turned on/off in protected mode, but you're allowed to change
filter criteria. I interpreted the OP's needs differently, but your method
may of course be a reasonable solution.
 
Top