unlock cells when previous cells are filled

[vicky.235235]

Hello,
I have an excel file where I want the user to fill the data compeletely and in the seqeunce of order. So far, I tried the VBA with sheet protect and unprotect, data validation using logical countif function. I encounter problems with the file file range method object failed or the excel file closes automatically. I have attached an example for my problem. I cannot decide whether to go with vba or data validation and if vba, go with sheet protect/ unprotect function.
I am using excel from Microsoft365.

Thank you

 

[Marc L]

Hi,​

​

first according to any Excel forum rules you must post a link on each other forum where you have created the same thread …​

​

 

[vicky.235235]

unlock cells when previous cells are filled (excelforum.com)

I hope that is sufficient

 

[Marc L]

Thanks.​

​

If you still need some help so according to your attachment - weird with blank row - can you describe a case, give an example ?​

​