Hi Sameer

Protection locks everything that you haven't spesifically marked "not
locked". So that's what you have to do, there are no "just a little
protection" methods anywhere.

--
HTH. Best wishes Harald
Followup to newsgroup only please

"sameerce " skrev i melding
...
Hi,
I wanted only some rows to be non editable by the user and rest of the
rows should be editable. I know that this is possible using the
protection option, but in this case it locks the whole worksheet. I wat
to lock only certain ranges in the worksheet without having to give any
password.
How can this be done?

Thanks,
Sameer


---
Message posted from http://www.ExcelForum.com/