Sorting Protected Worksheet
 

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!

Sorting Protected Worksheet
 

Do you have any locked cells in the range that will be sorted?

If you do, you'll get this error.

Marge wrote:

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!

--

Dave Peterson

Sorting Protected Worksheet
 

Hello Dave,

Yes, they want the whole spreadsheet "Locked" - but with the Allow "Users to
Edit Ranges" feature working for certain cells with a password (we gave them
that password access to certain columns in the spreadsheet). The whole thing
is locked, otherwise. I wasn't sure how this Sort thing works. I tried
Unlocking one of the columns, Protecting and then Sorting on that column, but
it still gives me the This Cell or Chart is Protected........, etc., warning.
Is it not possible to let them sort?

"Dave Peterson" wrote:

Do you have any locked cells in the range that will be sorted?

If you do, you'll get this error.

Marge wrote:

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!

--

Dave Peterson

Sorting Protected Worksheet
 

If there is any cell in the range to sort, then you'll have to find a different
approach.

Maybe just filtering to show what they want would be sufficient.

Maybe you could provide a macro that would unprotect the worksheet, do the sort,
and reprotect the worksheet.

Marge wrote:

Hello Dave,

Yes, they want the whole spreadsheet "Locked" - but with the Allow "Users to
Edit Ranges" feature working for certain cells with a password (we gave them
that password access to certain columns in the spreadsheet). The whole thing
is locked, otherwise. I wasn't sure how this Sort thing works. I tried
Unlocking one of the columns, Protecting and then Sorting on that column, but
it still gives me the This Cell or Chart is Protected........, etc., warning.
Is it not possible to let them sort?

"Dave Peterson" wrote:

Do you have any locked cells in the range that will be sorted?

If you do, you'll get this error.

Marge wrote:

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!

--

Dave Peterson


--

Dave Peterson

Sorting Protected Worksheet
 

If there is any cell in the range to sort
should be:
If there is any LOCKED cell in the range to sort

Dave Peterson wrote:

If there is any cell in the range to sort, then you'll have to find a different
approach.

Maybe just filtering to show what they want would be sufficient.

Maybe you could provide a macro that would unprotect the worksheet, do the sort,
and reprotect the worksheet.

Marge wrote:

Hello Dave,

Yes, they want the whole spreadsheet "Locked" - but with the Allow "Users to
Edit Ranges" feature working for certain cells with a password (we gave them
that password access to certain columns in the spreadsheet). The whole thing
is locked, otherwise. I wasn't sure how this Sort thing works. I tried
Unlocking one of the columns, Protecting and then Sorting on that column, but
it still gives me the This Cell or Chart is Protected........, etc., warning.
Is it not possible to let them sort?

"Dave Peterson" wrote:

Do you have any locked cells in the range that will be sorted?

If you do, you'll get this error.

Marge wrote:

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!

--

Dave Peterson


--

Dave Peterson

--

Dave Peterson