Sort on a protected sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Give them a macro that unprotects the sheet, sorts the data, then reprotects the
worksheet.
 
You must log in or register to reply here.

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

Sorting a protected sheet 1
Is autofilter & sort disabled in protected cells? 1
Excel Protection 2
Sorting a protected set of cells 3
Protected Sheets 2
Sort by setting two conditions 2
Lock spreadsheet but can sort 6
Sorting Linked Data Between Sheets 3

Back
Top