Lock cells in a row if a date is entered into an adjacent cell

[Simplyflorida]

I have a row of data in cells A5 to P5. When a date (ie Feb 26 2013) is entered into cell Q5, I want the whole row to be locked.

Need to do this for a complete range of cells (rows 5 to 500 for example).

I need to use VBA, but am not sure of the wording.

Any ideas please.

 

[Jubjab]

the code is only protecting the row in question, so other rows should not be affected. Maybe they got locked by mistake during your tests? Try with a clean sheet, with all cells unlocked first.