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.
 

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

Enabling Autofilter and Sorting in a Protected Sheet 2
how do i unproctect a work sheet, forgotten password 1
How To enable the Sort function for a protected Excel sheet 1
Sorting while protected - this question may not have been covered. 1
How to enable Copy and Paste when the sheet and workbook is protected 1
How to Sort within AutoFilter with Protection on (and AutoFilter . 1
Excel Sheet Protection 1
How do i enable "Group" & "Ungroup" in a protected sheet 9

Back
Top