Make sure that all the cells in the range to sort are unlocked.

Then select the range to sort, then sort.



"TraciAnn via OfficeKB.com" wrote:

I have a wb with several hidden sheets and hidden columns of the unhidden
sheets (When in UserView).

Although I turn on the "Sort" feature in the Protection options the user
still cannot sort the worksheet.

What do I need to do to keep the security but allow sorting?

--
---
TraciAnn

Message posted via http://www.officekb.com

--

Dave Peterson