Sort protected worksheet

[mdjks]

I have a file that I have password protected, selecting "allow all users to sort" but once protected an error is displayed when using Data Sort or A/Z sort button. Is there a way to allow users to a sort a protected worksheet?

Created in Excel 2003 but will be sent to various companies so end user version unknown.

 

[unmarkedhelicopter]

The only way I know of to do this is usnig code, have a button above each column your users will need to sort on and when then press it, it will unprotect the sheet do the sort and then reprotect.

 

[mdjks]

Thanks for the response, I was afraid code would be the answer. Does anyone know why Excel would give me the option of allowing users to sort then not let it happen?