Locked Cells Sorting

[Guest]

I have a sheet with a Range of A1:n2500. A1 to N1 are headers. I want to sort
the A2:N2500 data based on the header in C1. Some of the cells are locked
because I have formulas and dont want anyone to change these, and some are
unlocked. When I protect the sheet I check sort and selected unlocked cells.
When I go to srt, I get an error that Excel cant sort based on locked cells.

Anyone that can help me on this, or suggest an alternative VBA code. I am
not real up on VBA. Thanks, For any help

 

[Doug Kanter]

I have a sheet with a Range of A1:n2500. A1 to N1 are headers. I want to
sort
the A2:N2500 data based on the header in C1. Some of the cells are locked
because I have formulas and dont want anyone to change these, and some are
unlocked. When I protect the sheet I check sort and selected unlocked
cells.
When I go to srt, I get an error that Excel cant sort based on locked
cells.

Anyone that can help me on this, or suggest an alternative VBA code. I am
not real up on VBA. Thanks, For any help

How about UNlocking via code, doing the sort, then locking again? I don't
know if the password can be embedded in the code, but it might not even be
necessary. I made a sheet for other users and protected it, not because I
thought anyone would try anything evil, but just to guard against slips of
the finger or mouse. I locked the sheet WITHOUT a password. In 12 years,
nobody has figured this out. They don't even try.