Another Conditional Unlocking Thread

[jackmason]

I use excel regularly but only on a very basic level and have just started attempting to use macros. My problem is as follows, I am trying to build new time sheets for my various projects but my employees never fill them out right so I am making it that they must and cannot delete my formulas. Also, the way our accounting works I like to keep all of the names on the sheet and in the same order for that pay period. What I have done is locked all of the cells where the names go with the exception of the first worksheet and then put a formula into all subsequent worksheets (14 total) that for example if B11 = B11 on sheet 2.
What I would like to do is the following:
If B11 (which equals whatever was inputted in the previous sheet) is blank then unlock otherwise stay locked. Now I have tried a few formulas that I had sourced out on the net and have been messing with this for about 2 hours but I think I am just lost. Any help would be appreciated.

[FDibbins]

Hi, welcome to the forum

It is always better with something like thyis, if you could upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

Have you considered making them add names at the end of the list instead of the beginning/middle?

[jackmason]

Hi, welcome to the forum

It is always better with something like thyis, if you could upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

Have you considered making them add names at the end of the list instead of the beginning/middle?

Thanks for the advice, I just got home and this on my work computer. I will upload a copy in the am

[jackmason]

DTS_New Template.xlsx

Here is the attached, so basically is what I am looking to do is:
- on the first tab B11:B30 is unlocked to enter employee names
- all cells in B11:B30 on the second sheet that auto-populate the names entered on previous sheet will be locked and all others in that column will be unlocked for future entry
- if someone adds names to the list on sheet two, those cells in the next tab will auto-populate and be locked and all blank will be unlocked, and so on...

I have locked the sheet so you can see what I am going for but for the purpose of this copy the password will be: password

[jackmason]

I just noticed a couple of errors on that sheet that do not appear on my main sheet, the dates in summary I will fix and the names that show "0" in summary I have been addressing by formatting the cell in custom with 0;;;@