View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Graciegirl Graciegirl is offline
external usenet poster
 
Posts: 8
Default How do I protect a range but allow auto filtering in earlier versi

I created a s.s. that needs to be protected from anyone changing it but
anyone needs to be able to use the auto filter. I created it in 2007, saved
as earlier version. I picked allow users to select unlocked cells and use
the auto filter but it still doesn't work except in 2007. So, how would I
protect the sheet and be able to use the auto filter in earlier versions?

--
Gracie