View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JP JP is offline
external usenet poster
 
Posts: 103
Default Lock cells but allow sorting and filtering

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.