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.