Spreadsheet Protection & Sort

J

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
 
E

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.
 
J

John

Thanks, that'll work!

John

Earl said:
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.
Click to expand...
 
Top