View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Beto
 
Posts: n/a
Default Excel Sheet Protection

I am trying to protect a spreadsheet from any editing, while allowing the
user to use the autofilter and sorting function. I tried checking the "Use
AutoFilter" and "Sort" checkboxes in the Protect Sheet dialog box to protect
the document. It does allow you to filter records based on selecting a value
from the drop down list box of the autofilter, but it does not allow me to
sort.

Please help!