Thanx Sir my concern is resolved by using:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
For Each cell In Range("Y3:Y500")
If cell.Value = "Yes" Then
ActiveSheet.Unprotect "Password"
cell.EntireRow.Locked = True
ActiveSheet.Protect "Password"
End If
Next cell
End Sub
Facts:
We have a protected worksheet wherein all rows represent data pertaining to one client invoice
e.g. Row 3 have data pertaining to Invoice No. 1 from column A to X
wherein data can only be selected from drop down lists in column A to J (unprotected cells)
Column K to X are protected...