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/