How do I sort locked cells in Excel?
Thanks - I'll see if I can make that work. I guess I'm missing the logic of
why locking fields but choosing "sort" when protecting the worksheet would
not work. Guess that's why I'm a nurse and not a programmer......
"Redskinsfan" wrote:
Cathy,
Well im a newbie but i had almost same prob as you with locked cells, i had
a macro they needed to run but would'nt cause they dont have formatting
rights once the doc is protected. Well i had to put this line at the begining
of my macro
ActiveSheet.Protect UserInterfaceOnly:=True
if you have it protected with a pass theres another line that uses ur
password, however in my case i just took off my pass and just protected the
form.
"Cathy" wrote:
I've created a worksheet with one column of data (hospital room numbers) that
always remain constant. I have 5 columns where data (numbers) will be
entered daily. I have a calculation column where the numbers in the previous
5 columns are totaled (hidden column). I then have a last column that
returns a specific word based on the value in the previous calculation
column.
I need the first column with room numbers, the hidden column with the
calculation, and the last column with the word value to be locked so they
cannot be manipulated. I can do all those things very easily.
The problem is that a user will have to enter data in the middle 5 columns,
and then sort the spreadsheet, and Excel will not allow a sort using the
locked fields.
Any suggestions?
|