could someone tell me how to lock cells automatically in excel.

i have a date field in column a and i want the code to look at the cells in column a and lock the whole row if that cell is greater that 1 week old.

i dont use a password in the protect sheet but i just want to limit accidental deletions or alterations.


thanks