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

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.

Beto wrote:

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!


--

Dave Peterson