Excel Sheet Protection


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!
 
Ad

Advertisements

D

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

Top