Lock a row when not blank but also lock cells marked as locked

I used this post: "Lock A Row With An Entry In Col B On Saving Or Closing Workbook" to assist me initially and with a bit of tinkering I got pretty much what I wanted. I want to lock the rows that have data entered and leave only the blank rows editable when I click save, but I also have columns within those rows which have formula that I want protecting all the time.

I can unprotect the whole sheet, mark the cells I want locked as locked and then protect the sheet and it works. But then when I click save it locks the rows that are not blank as desired but unlocks the columns with formulas. It seems to me that I just need another line in the ThisWorkbook code which says protect the cells ticked for locking as well as the rows but I am unable to find.

This is my code, please advise:

Please Login or Register  to view this content.

Please take a moment to read the forum rules and edit your post to include code tags.

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Select your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button).

Dom