You should be able to record a macro (after you've unprotected the sheet) to
sort either ascending or descending.

Then you'll have the code for that portion.

Roady wrote:

Hi:
I have an Excel document that is protected. There are macros buttons on the
page which contain un-password protect and then re-protecting at the end to
allow it to perform certain functions for the end-user. However, when I try
to sort ascending or descending, it does not allow it. What is the code for
this?

thank you,
Jen

--

Dave Peterson