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 **
