I am trying to protect a worksheet, but still allow the users to "sort". I
have gone to the Protection dialog box and selected the select locked and
unlocked cells (where they can enter their data) and then I selected the the
Sort and the Use AutoFilter. I did put on a password.
When my users go in, they can enter their data and they can access the
AutoFilter feature and that works, but they can't sort...it just gives them
the "protected cell" warning. Is there something else I need to do?
Thanks!