How can I use Data/Filter/Auto Filter on a protected sheet, with or with out a password. Thanks Sam
S samcannet1 Aug 15, 2007 #1 How can I use Data/Filter/Auto Filter on a protected sheet, with or with out a password. Thanks Sam
T Tim879 Aug 15, 2007 #2 If you're using Office 2003 or greater, protect the spreadsheet as follows: Tools->Protection->Protect Sheet In the box that appears, scroll down and select Use AutoFilter.
If you're using Office 2003 or greater, protect the spreadsheet as follows: Tools->Protection->Protect Sheet In the box that appears, scroll down and select Use AutoFilter.
G Gord Dibben Aug 15, 2007 #3 The autofilter must be set on before protecting the sheet. Gord Dibben MS Excel MVP
