lock page until data validation cell is completed?

[splitpeanut]

Is there a way to lock all the other cells on a worksheet until one “required” data validation cell is completed?

Or could this function possibly work with a combo box?

Actually, this would be great if a series of cells were required to be completed in succession before the next field is unlocked...

thanks,
Jon

 

[ColinKJ]

Hi Jon ,

I don't think this is possible using formula, but it would be possible with VBA, are you open to a VBA solution.

 

[splitpeanut]

Hi Colin,
Yes, a VBA solution would be great! Thanks!
Jon.

 

[mikerickson]

If D4 is the critical cell, you could put Validation on all the other cells with the formula

=(LEN($D$4)>0)
and uncheck the ignore blanks box.

 

[ColinKJ]

Hi Jon,

I've sent you a PM with my email add if you are able to send me a copy of your form, along with detail of which cells are involved, and in which order.

If your unable to send your form, can you let me know detail of which cells are involved, and in which order.