Sheet Protection, Allow Sorting
Lucy
I don't think you're missing anything.
The range to be sorted must be unlocked before protecting the sheet.
i.e. B6:M284 must be unlocked.
Excel help is little fuzzy on this point.
Best method is to use a macro which unprotects, sorts and re-protects.
Gord Dibben MS Excel MVP
On Mon, 6 Nov 2006 15:44:01 -0800, Lucy wrote:
This seems like a really old question, but I just can't figure it out...12
hours later.
Spell it out for me please...
I have a spreadsheet with a pretty header, column headers, and want to
protect my document from data being changed only, but allow for sorting data
(all columns) within range B6:M284.
Give it to me as if I were in kindergarten...I'm not getting it!
Thanks in advance for any help. You will be my hero if it works!
Lucy
|