View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RJH RJH is offline
external usenet poster
 
Posts: 44
Default Autofilter and protection

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