Using the "sort" on a protected sheet

Hi Victoria, Thanks for the post, It seems as though you have followed the correct method of allowing users to sort; so I am a little bit flummoxed as to why it's not working;
For others who may be interested; If you are using Excel 2002, Excel 2003, or Excel 2007 the answer is reasonably straightforward: These versions of Excel allow you to specify what users can and cannot do with a protected worksheet. When you choose Tools>Protection>Protect Sheet (Excel 2002 and Excel 2003) or click the tab to display the Review ribbon and click Protect Sheet in the Changes group (Excel 2007), Excel displays the Protect Sheet dialog box. At the bottom of the dialog box is a long list of check boxes.
All you need to do is select what the user should be able to do with the worksheet. One of the options (you need to scroll down a bit) is Sort. If you select this option, then users can sort protected data.
Thats the theory behind it, so I cannot see why your worksheet is not operating correctly, please come back if you are still having a problem, best regards Pete