View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brendan Vassallo
 
Posts: n/a
Default Using Autofilter on a Protected Worksheet

I am using XL 2000. The sheet I have requires the AutoFilter function,
however I also wish to protect it. When I do protect it, the AutoFilter does
not work. Is there any way around this. I know if I was using XP there is
an option to protect the worksheet but leave the AutoFiler functioning, but I
can not find that option on the XL 2000 version I am using. Please HELP!!!