View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
munchkin munchkin is offline
external usenet poster
 
Posts: 57
Default Is autofilter & sort disabled in protected cells?

My spreadsheet is protected, but I have checked off the boxes to allow users
to use autofilter & sort, but since my cells are protected (because I don't
want anybody to change any records in the document) the autofilter sort
feature does not work. Is there any way around this? Thanks.