autofilter in protected worksheet

  • Thread starter Thread starter Ki
  • Start date Start date
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
 
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 **
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Enabling Autofilter and Sorting in a Protected Sheet 2
Using Autofilter on Protected sheets 3
AUTOFILTER IN A PROTECTED WORKSHEET 1
Autofilters not working when sheet is protected 10
Autofilter does not work on protected w/s even when "checked to allow" ?? 6
MS Excel 2003 - Autofilter for protected cells 1
Sorting while protected - this question may not have been covered. 1
Using Autofilter on a Protected Worksheet 1

Back
Top