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

Please help!



Dave Peterson

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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question