Sorting/Using Autofilter in a Protected Sheet

[krazylain]

I've protected my excel spreadsheet, and left an unprotected area wher
i can insert comments and make changes to records.

I checked the appropriate boxes to allow users to select locked o
unlocked cells, to format rows or columns and also to sort & us
autofilter.

The problem occurs once the sheet is protected. The sheet cannot b
sorted. A message pops up saying that the sheet is protected an
users will have to unprotect the sheet to use the sort function.

Anyone knows how I can protect the sheet, while allowing sorting o
records

 

[Frank Kabel]

Hi
äwhich Excel version are you using?

 

[krazylain]

I'm using Excel 2002.

thank

 

[Frank Kabel]

Hi
not sure about Excel 2002 but in Excel 2003 you can set such option to
allow sorting/filtering within the dialog for 'Tools - Protection -
worksheet'

 

[krazylain]

that's what i did, but it still doesnot allow me to sort...though I ca
insert columns etc.

 

[Dave Peterson]

All the cells in the sort range need to be unlocked.

I like to explicitly select my range to sort. Are you letting xl guess?