Hello,

I have a list in Excel 2000, the values in the list are derived from
formulas in the cells of the list. I use an autofilter to sort out the
blank cells in the list. The problem: I would like to protect the list to
keep the formulas intact, but when I protect the list the autofilter won't
function. I've tried unlocking the cell with the filter button, no good. I
tried each one of the switches on the protect (password) window, no good.

Is it possible to protect the list and keep the filter functional?

Thanks!

RJH