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

Thanks,
Samee

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

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/

Hi sameerce;
For example (the user is likely to be surprised)

Dim oldCell As String

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If oldCell = "" Then oldCell = "A1"
Select Case Target.Row
Case 10, 12, 14, 16, 21 To 23: Range(oldCell).Select
Case Else: oldCell = Target.Address
End Select
End Sub

MP

"sameerce " a écrit dans le message de
...
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/