Sorting a protected worksheet

  • Thread starter Thread starter Kevin
  • Start date Start date
K

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
 
Hi
one way:
create a macro that first unprotects the sheet, sorts it
and protects it again
 
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
 
Back
Top