Locked Cells Sorting

Giganews Newsgroups
Subject: Locked Cells Sorting
Posted by:  JackR
Date: Mon, 8 May 2006

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

Replies