How to enable the sort function for a protected sheet

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Not as easily.

You could provide a macro that unprotects the worksheet, does a sort, then
reprotects the worksheet.
 
Back
Top