Lock/Unlock cells based on value in another cell

Hey guys,

I'm sorry for creating this thread because I know that this question has been asked so often. I'm pretty new to excel, let alone Visual Basic. I just got promoted to supervisor of an organization that deals with a lot of data entry and I'm just looking for ways to reduce human error, increase speed, etc.

For this specific situation I have a sheet similar to the one below with the data entry fields visible unlocked. there are like 500 fields down the whole sheet but I'm primarily concerned with just the first one and I can figure out doing the rest later.

As seen in the document I uploaded I have fields for the group number, code, whether or not it was called in, etc.. The thing is that not all these entry points are required for all the codes that my organization uses. What I want is for all the entry point cells to be unlocked until the code BC or LC is used. Then I would like the cells for Called, E-Number, and number in party to be locked. But then when the code is changed to 1015 or left blank, for the cells to again be unlocked. I know that I'll have to use An If-Then statement. I've tried copying other people's codes who are attempting to do the same thing and just change the cell numbers to meet my needs but I can't seem to get it right. Could you guys help me out by writing a code for me? Try to keep it somewhat simple so I can make small changes if any problems arise.

I will really appreciate any help. It has been somewhat stressful and time consuming, trying to figure this out.

I don't see any attached workbook. Can you do it again?

Look at the attached workbook.
You can try it. By default, the sheet is protected and the password is Password
The blue cells are usually not locked so you can change them. But if you enter BC or LC in the code cell, then you'll have 3 locked cells in F4, J4 and K4.

In a module, I left 2 macros for you to use or not. One is to protect the sheet and the other one to unprotect it. I find it handy to have those available but you might not want to leave them in your final workbook though.

Hopes this helps