Sorting a protected worksheet

[Kevin]

I am distributing a workbook for people to edit and
return. I need to lock/protect the sheet so they can only
change certain cells.

Unfortunately, this locks the ability to sort a column.
Is it possible to still have a locked spreadsheet, but
still sort? Need it to be compatable w/ Excel 97.

Thanks in advance!
Kevin

 

[Frank kabel]

Hi
one way:
create a macro that first unprotects the sheet, sorts it
and protects it again

 

[Guest]

Frank,

Thanks for the reply. I thought of that, and I'm working
on it, but that raises another question- I would like for
the sheet to have a password, is it possible to pass a
password progmatically?

Thanks again,
Kevin