View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Suresh
 
Posts: n/a
Default Applying autofilter to protected sheet

From the Tools menu under protection option Enable "Use Auto filter"

I Use Excel 2003

"Brian Ferris" wrote:

Hi guys,

I wondered whether a user of a protected sheet can filter the rows while
still having the sheet protected .... Any suggestions ?

Thanks in advance,
Brian