Spreadsheet Protection & Sort

[John]

Is there a way to protect a spreadsheet (just one column of cells) yet
allow for the spreadsheet to be sorted?

Thanks for your help in advance.

John

 

[Earl Kiosterud]

John,

If you want to sort only the unlocked cells of a protected sheet, you can do
so with XL2002. In Tools - Protection, you have to option of allowing sort.
Not available in XL97, don't know about 2000.

In 97, it's generally done with a macro that unprotects the sheet, does the
sort, then protects the sheet.

 

[John]

Thanks, that'll work!

John

John,

If you want to sort only the unlocked cells of a protected sheet, you can do
so with XL2002. In Tools - Protection, you have to option of allowing sort.
Not available in XL97, don't know about 2000.

In 97, it's generally done with a macro that unprotects the sheet, does the
sort, then protects the sheet.