Lock specific cells in a row when value entered into another cell

[sandyb]

I have developted a workbook that will be located in a common folder with limited user access.

The spreadsheet has code that will populate a "time stamp" when a value from drop list is selected in a different cell. I need for the certain cells in that row to lock once that time stamp populates - without locking any other cells/columns in the sheet.

Any and all suggestions welcome and appreciated.

 

[imla]

Hi,

VBA solution: you can use a Worksheet_Change or Worksheet_SelectionChange(...) and play with Target to look only the cells that you want!