[JP]

Is there any way to Lock cells such that the cell values cannot be changed
but still allow sorting and filtering?

I have gone through the steps of Locking all cells on a worksheet and then
protecting the worksheet with a password. When protecting the worksheet I
have checked the boxes to allow for sorting and filtering. However, when I
go to the Data menu, the AutoFilter is grayed out and when I try to sort I
get the message saying that the worksheet is protected and that it must be
Unprotected before any changes can be made.

Thank you for your time and assistance.

[[email protected]]

I am not sure of the best way to make Sort work on a protected sheet.
However, I have successfully made AutoFilter work on a protected
sheet. Before you protect the sheet, select Data Filter
AutoFilter. Then the AutoFilter arrows will appear on the column
headers. Now protect the worksheet, and make sure to check the box
Allow all users of this worksheet to: Use AutoFilter. You will be
able to use some AutoFilter functions, but not Sort Ascending or Sort
Descending. You will also not be able to select Data Filter Show
All when the worksheet is protected. All users will be able to use
AutoFilter, but they will not be able to remove the AutoFilter arrows
from the column headers.

[JP]

Thank you for the help.
I guess Auto Filter will have to suffice.
If somebody needs to sort, they will just have to Copy & Paste the data into
a new workbook and sort it there.

" wrote:

I am not sure of the best way to make Sort work on a protected sheet.
However, I have successfully made AutoFilter work on a protected
sheet. Before you protect the sheet, select Data Filter
AutoFilter. Then the AutoFilter arrows will appear on the column
headers. Now protect the worksheet, and make sure to check the box
Allow all users of this worksheet to: Use AutoFilter. You will be
able to use some AutoFilter functions, but not Sort Ascending or Sort
Descending. You will also not be able to select Data Filter Show
All when the worksheet is protected. All users will be able to use
AutoFilter, but they will not be able to remove the AutoFilter arrows
from the column headers.