Hi Erika-
First are you password protecting the sheet or just turning on protection.
If the later, I have some code that will do the sort for the user. Let me
know and I will see what I can do to assist you.

David

"Erika" wrote:

I have a huge spreadsheet that contains a list. I don't want people to be
able to modify the data in the spreadsheet but I do want them to have the
ability to sort.

I have protected the spreadsheet and checked sort however they get an error
when they try to sort. Am I missing a step?