I am a novice user excel vba, I tried so many macros to implement protect and lock rows on a used range in a work sheet, but they never fullfilled my reqirement..I have a customer complaints log w/ sheet with each row a customer complaint is entered from a:e range, action taken on this complaint is entered from f:j through datavalidation lists, contains in these f:j columns, and last column range 'k' value based on a formula 'open'/'closed'.My requirement is whenever any row 'k' cell value is 'closed' the row values a:k be locked and protected from being edited by others whether sheet is protected or not and whenever I open that sheet for further entry of sheet data those rows should not be edited or modified, whenever I select these rows excel should give warning that the cell is only for read only.