Lock row based on one cells value

[richie.oliva]

Im looking to be able to lock a row based on a cells value.

If CELL AC7 = a value of "RETURNED" I would like to lock Cells A7:AB7 that would require the sheet to be unprotected to make changes.

I need to repeat this for all rows on the sheet starting at row 7. Any help would be greatly appreciated.

[wk9128]

Please copy this code in your active worksheet

Did I help significantly? If you wish, click on * Add Reputation to say thanks.
If your problem has been resolved please select “Solved” from the Thread Tools menu

[maniacb]

Apply the following code, but first you must unlock all the cells in the worksheet(Select all cells, rt clck->Format, Select Protection tab, deselect Locked). And place code in the worksheet module. Let us know if you have questions.

Please Login or Register  to view this content.

[wk9128]

Unlock cell pls use this code

[richie.oliva]

I cant seem to get that to work. i attached the file im working with right now. you will see each row at column AC has a drop down. if the drop down is changed to(RETURNED, DESTROYED, DONATED) it should lock that row from editing and need a password to be able to. If the column is empty or shows SECURED it could still be edited. i hope this makes sense. Thank you for your help

[richie.oliva]

I did get this to work. Thank you very much. can you tell me though if column AC has either (RETURNED, DESTROYED, DONATED) in it to do the same thing as locking that row? Again thank you for your help.

[maniacb]

You should know, my code only reacts to "Returned", not the capitalized version.

Update this line:

Please Login or Register  to view this content.