Lock and Unlock an entire row based on a condition

[dtr9000]

Hi, am looking for a macro to lock cells of an entire row when another cell has meet a certain condition. I have only basic VBA experience. See attached Spreadsheet with my example.

Basically a user enters data into rows A3 to G3, and when done selects "Completed" in the drop down list in H3. This should then lock all cells to the left of H3 e.g. when the user selects "Completed" in cell H3 all the cells (A3 to G3) to the left of it should be locked. Then the user moves onto the next row (A4) to enter data there. If the user makes a mistake, they will need a password to unlock the locked-row to make changes, so maybe a prompt when they select "Completed" that tells the user that they won't be able to make changes if they choose "Completed". If column H3 to H infinite "Is Blank" or "Not Completed" is selected, then the user can edit the rows before it.

[jaslake]

Hi dtr9000

Welcome to the Forum!!!

Try this Code in the attached. Password is set as "password". You'll need to set it as you desire in two places as indicated...
This Workbook Code..

Please Login or Register  to view this content.

Worksheet Change Code...

Please Login or Register  to view this content.

[dtr9000]

Thanks jaslake

[jaslake]

You are welcome dtr9000...thank you for the Rep Points...
John