If you have Excel 2002 or later select Use AutoFilter in the Tools,
Protection, Protect Sheet dialog. Otherwise I think you're out of luck.

--
Jim
"ranvin56" wrote in message
...
|I have a spreadsheet with several formulas and conditional formating in
place
| with filters on each column. The problem is if I protect the worksheet the
| filters don't seem to work. Does anyone have a suggestion?