Spreadsheet Protection & Sort

  • Thread starter Thread starter John
  • Start date Start date
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
 
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.
 
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...
 
Back
Top