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
|