Macro to lock rows based on two conditions

[fpt264]

I have a sheet with 9 columns and 1,000 rows. The first two rows are Title and column headers and are always locked.
Column I, containing a formula, is always locked.

I would like to lock the other columns A thru H in each row 3 thru 1,000 where the following conditions are true:
Col. A (Date) is more than 10 days in the past, and
Col. F contains an "x"

I've spent the best part of the weekend trying to figure this out and have come to the conclusion its time to ask for help.

[Olly]

Use something like this to lock a specific row:

Please Login or Register  to view this content.

Now, you can call this for all rows in your range, with something like:

Please Login or Register  to view this content.

And / or you can do this dynamically as the worksheet changes, by putting this in the worksheet module:

Please Login or Register  to view this content.

[fpt264]

Thanks for your response. I will see what I can do with these suggestions.

[fpt264]

Thanks for your response. I will see what I can do with these suggestions.