VBA code for mandatory cells - only allow to save if complete

Hi,

I'm brand new to using VB and have been playing around with setting up a VBA code for mandatory cells in excel for last few weeks.

I only managed to get it done for 1 cell but actually i need to apply for multiple cell in sheet.

Let me try to explain my problem and hopefully someone can give your expertise to resolve it.

I need a vba code that checks if multiple cells are complete before saving.

-->I have a template including 1000 rows and 20 columns (A20:O1019). User of the template have to ensure all the blank is filled, meaning that as soon as there is a single cell entry in the Column E (start with E20), all the blank must be filled in (until column N).
The template only can be saved if an entire row completely filled or remain empty.

note: column B, C, D, F, J, L are either hidden and/or contain formulas which already been locked and auto populate (Example: when you type in column E, then data in B,C, D, F will be appeared).

Besides, i have few sheets in 1 document, should i set the same VBA on each sheet or set in one of it will do?

Would very appreciate any help.

Regards,
Lina

sample.xlsx

Hi Pareshj,

Thanks for your reply.

attached is the sample of my file.

The result should be:

If the data is completely filled (refer to 1st line), it consider a complete data and allowed to save.
however, if there is a SAP ID enter (2nd line) but the rest of the field did not fill up, this file can't save.

Meaning to say, from B20 until N20, they are a mandatory cells (those in purple color) which need to fill up before save.
It either should be fully filled from B20 to N20 or blank the whole line.

Those cell with grey color is already pre-fixed where when you key in data in purple cell, the information will automatically prompt out.

Let me know if i missed out any information.

Thank you very much in advance on your kind assistance.

Anyone can help? T_T

Originally Posted by sqinm

Attachment 329939

Hi Pareshj,

Thanks for your reply.

attached is the sample of my file.

The result should be:

If the data is completely filled (refer to 1st line), it consider a complete data and allowed to save.
however, if there is a SAP ID enter (2nd line) but the rest of the field did not fill up, this file can't save.

Meaning to say, from B20 until N20, they are a mandatory cells (those in purple color) which need to fill up before save.
It either should be fully filled from B20 to N20 or blank the whole line.

Those cell with grey color is already pre-fixed where when you key in data in purple cell, the information will automatically prompt out.

Let me know if i missed out any information.

Thank you very much in advance on your kind assistance.