How to enable the sort function for a protected sheet

G

Guest

After proctecting 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

Not as easily.

You could provide a macro that unprotects the worksheet, does a sort, then
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

How To enable the Sort function for a protected Excel sheet 1
Enabling Autofilter and Sorting in a Protected Sheet 2
Sorting while protected - this question may not have been covered. 1
Protected worksheet allow users 1
Macro & Protected sheet 2
Custom Filter that Displays All But in Ascending or Decending Orde 3
Sorting/Using Autofilter in a Protected Sheet 5
Autofilter not working on protected sheet. 1

Top