Not as easily.

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



lkjing wrote:

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.

--

Dave Peterson