Sort on a protected sheet

M

mac

I have a spreadsheet that I do not want anyone to change. but I do want them
to be able to sort. Is there any way to do this? Any help will be
appreciated. Thank You
 
D

Dave Peterson

Give them a macro that unprotects the sheet, sorts the data, then reprotects the
worksheet.
 
Top