How to enable the sort function for a protected sheet

L

lkjing

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.
 
Top