Recent content by gguglani

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...