If cell is empty then lock the next one and don't save the file

[PaulM100]

Hi,

I have a file that has a number of columns in which the users will have to add data. But I want them to add all the data to be used on a later stage as until now they've skipped some important information.
What I am trying to do is:

If A2 is empty then B2 is locked;
if B2 is empty then D2 is locked;
If D2 is empty then E2 is locked;
If E2 is empty then F2 is locked;
If F2 is empty then G2 is locked;
If G2 is empty then H2 is locked;
If H2 is empty then I2 is locked;
If I2 is empty then J2 is locked.

Also, if they have not completed the conditions above, then they cannot save the file.

Is it possible only via VBA?

Thanks,
Paul

[kev_]

Something like this
- test in attached workbook

In sheet module:

Please Login or Register  to view this content.

In ThisWorkbook module:

Please Login or Register  to view this content.

[PaulM100]

Hi Kev,

Thank you for your response and the code. It works like a charm. You sir, saved me from a lot of workaround.

Regards,
Paul