When you go to Tools-Protection-Protect sheet as you normally would to
protect a sheet, there is a Use Autofilter checkbox neat the bottom. xl2003
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"The BriGuy" wrote:

I have a worksheet with filters on several columns. Does anyone know of a
way to protect the entire sheet so other scannot make changes to data and
also allow the auto-filter to work so data can still be filtered as needed?

Thanks