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.

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.

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?