Lock rows based on value in another column

[pumped]

Hi All

I need any assistance to create a macro (Excel 2003) to lock all the level 1 & 2 rows in the attached worksheet, this is a cutdown highly modified example of a model I have.
I have a macro to populate the sheet on a monthly basis at the same time I would like the macro to look for all cells in Column A that have the value 1 or 2 and then lock the whole row, also if it does not have those values in it, it should keep it unlocked.

I have googled and searched this Forum to no avail if I have missed it please can you just point me in the right direction.

Regards,

Added:
Instead of using a Macro I used Data Validation, Custom and used the Formula "=$A2<>2", remembering to de-select "ignore blank" checkbox.

[davesexcel]

Why would you want to do this?

[pumped]

Hi Davesexcel

How the model works is a dump of data from SAP is extracted and then pasted into another sheet, based on the dump in this sheet the main sheet updates and a line that was a level 3 could change to a level 2 or vice versa.

The point behind my question is to lock the level 2 rows so that the user can't overwrite the sum formula, after he has updated the main sheet with the new SAP information.

Thanks