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.
 

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

Similar Threads

Sorting while protected - this question may not have been covered. 1
Enabling Autofilter and Sorting in a Protected Sheet 2
Using Autofilter on Protected sheets 3
Autofilter does not work on protected w/s even when "checked to allow" ?? 6
MS Excel 2003 - Autofilter for protected cells 1
Autofilter not working on protected sheet. 1
How to Sort within AutoFilter with Protection on (and AutoFilter . 1
ProtectSheet Options are un-checking after macro 9

Back
Top