You could give the users a macro to sort the data. Your macro would do the
unprotecting, sorting, and reprotecting.

I like this technique from Debra Dalgleish's site:
http://contextures.com/xlSort02.html#Rectangles
Sort With Invisible Rectangles



WCM wrote:

I am working on an Excel 2000 VBA project. The users of the main sheet in
this workbook complain that sometimes users will inadvertently sort only the
first few columns of the sheet so that the data in the sheet gets
"discombobulated" - the data in the sorted columns no longer relates properly
to the data in the other, non-sorted columns. For example, if the sheet
contains two columns - firstName and lastName, and the user sorts only the
firstName column in alpha order, the names are no longer properly associated.

Excel does not always warn the user that he is sorting only some of the
columns in the sheet.

Question: Is there a Best Practice for ensuring that users do not sort by
only some (not all) columns in a sheet? Or is there a best method for
ensuring that should the bad sort happen, the records can be returned to
their original state, even after a save?

Thanks in advance for your help ...

Bill

--

Dave Peterson