View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mickey mickey is offline
external usenet poster
 
Posts: 112
Default Protect Autofiler Column

How can I Protect a Worksheet that has a autofilter column. I want users to
be able to use the drop down menu in the autofilter column to narrow the
selections but I don't want users to have the ability to change anything on
the spreadsheet. If I unlock the autofilter column and protect the sheet it
doesn't activate the dropdown.

Thanks,
Mickey