View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ShawnDoeX ShawnDoeX is offline
external usenet poster
 
Posts: 1
Default Protect Sheet but allow sorting

I am using Excel 2003 and I am having similar problems protecting a sheet
from editing while allowing sorting.

I have protected the sheet with the "sort" option switched on. If I do not
do this, the "sort" option in the "tools" menu would be greyed out and
unselectable. However, even with the option switched on so that the sorting
option is at least selectable, I STILL get an excel warning that the
worksheet is read-only and that I should unprotect the worksheet to sort it
?!!

Help please!