VBA Lock Row based on content in column

[Kausch]

I've looked (with little success) for a Macro that is able to protect an entire row based on the value in Column B. For example, Column B is my index with unique values - some starting with the word "TEMP" as a prefix (e.g. TEMP1234). Those rows with cells in Column B that DO NOT have a prefix of "TEMP" must be kept unprotected so they are editable by a number of users, whereas rows where cells in Column B do not have that prefix of "TEMP" (always 6-digit numeric identifiers) must be protected (not necessarily with a password). I will run the VBA code on opening and closing the workbook and I am able to do that on my own.

In summary, I want to lock/protect rows where cells in Column B have 6-digit numeric numbers and where the prefix "TEMP" is absent. Any quick code solution would be extremely helpful.
Thank you again in advance.

[Kausch]

OK, I've managed to resolve my own problem with the following code:
In Module

Please Login or Register  to view this content.

In Sheet

Please Login or Register  to view this content.

HOWEVER
The above code seems to protect everything (even when it finds blank cells in Column B) and only unprotect rows that have a prefix of "TEMP" in Column B. I really need it modifying so that it "unprotects everything" and only protects those items NOT using the prefix of "TEMP" in Column B. Also...
...I am working from a "Table" where one would press the <TAB> key on last cell to add a new row - the Protection seems to stop allowing me to add a new line!
Can anyone advise please?