View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Auto Filter - Protected sheet/workbook

I've never noticed any difference in behavior between xl97, xl2k, xl2002 and
xl2003.



ronwill wrote:

Thanks Dave, I'll give that a try. It seems the reason for filters not
working is related to the version of excel, only when the sheets are
protected (unprotected works on Excel 97 to 2002). I am saving them as
97 versions to see if that works for the auto filter issue when the
sheet is protected.

--
ronwill
------------------------------------------------------------------------
ronwill's Profile: http://www.excelforum.com/member.php...o&userid=30277
View this thread: http://www.excelforum.com/showthread...hreadid=499449


--

Dave Peterson