Protected Sheet Disables Autofilter

  • Thread starter Thread starter Amy
  • Start date Start date
Amy,
In Excel 97 and later you can use an AutoFilter on a protected sheet if you
(1) enable it, and (2) protect the sheet with Userinterfaceonly set to True:

The later setting is not retained with the workbook when saved so it must be
reset when the workbook is re-opened.

Private Sub Workbook_Open()
Sheet1.EnableAutoFilter = True
Sheet1.Protect userinterfaceonly:=True
End Sub

In Excel 2002 you can enable AutoFilter through the user interface (Tools,
Protection, Protect Sheet).

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
You must log in or register to reply here.

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

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

Back
Top