How To enable the Sort function for a protected Excel sheet

G

Guest

After protecting my sheet with a password, I found that the sort function
will be not available to users without the password. Realized Autofilter can
be enabled using codes. What about "sort" function? Thanks.
 
D

Dave Peterson

See one reply to your post in .misc.
After protecting my sheet with a password, I found that the sort function
will be not available to users without the password. Realized Autofilter can
be enabled using codes. What about "sort" function? Thanks.
Click to expand...
 

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

How to enable the sort function for a protected sheet 1
Spell Checking on a protected sheet 1
Enable autofilter in protected worksheets in Excel 2000 6
Sheet protection complications 4
Unable to sort protected table 9
Sort-function of AutoFilter doesn't work, when sheet is protected 4
lastrow function help 6
Sort list by selecting header cell? 3

Top