How to apply VBA in every row

Hi All,

im trying to make some sort of a daily report where in column "R" has a drop down list of its status.

i.e. in row 6.
once the work is finished, the staff will choose "COMPLETED" in column R6.
What i would like to happen is that whenever they chose that word, selected cells in row6 will be locked or protected.

i've manage to create VBA but it only applies to row6 only. would like apply the same rule in every row.

please advise.. VBA i created is here...

----------------------------------------------------------------------------

Please Login or Register  to view this content.

---------------------------------------------------------------------------------------------

Thank you in Advance !!!

Hi and welcome to the forum. Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

To do this highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Since this is your first post I'll add the code tags for you but please remember for the future.

Hi

Try:

Please Login or Register  to view this content.