Excel Sheet Protection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
If you have locked cells that are in the range to sort, then checking that box
in the tools|Protection|protect sheet dialog won't work for you.

You may want to provide a macro that unprotects the worksheet, sorts the range,
and reprotects the worksheet.
 
Back
Top