VBA Stop Workbook From Closing Unless Data Is Filled Complete

[MATRIXOFFICE]

ok the name of the entire workbook is incident spreadsheet

incident type is entered into column G (Say G6)

the extra data should then be entered into columns M N and O (M6 N6 and O6 would then match data in G6)

so the script must look at data in G (again for example G6) and see data in M N and O 6 so we can be compliant with our data collection..

hope that helps

thanks

[Rick Rothstein]

ok the name of the entire workbook is incident spreadsheet

incident type is entered into column G (Say G6)

the extra data should then be entered into columns M N and O (M6 N6 and O6 would then match data in G6)

so the script must look at data in G (again for example G6) and see data in M N and O 6 so we can be compliant with our data collection..

hope that helps

Okay, I misunderstood what you wanted when I read your original message... you have many rows of four data cells to check, not just four individual cells. No problem, but I need two pieces of information from you. First, I need the name of the sheet that contains the data being checked (you gave me the workbook name which I do not need). Second, what row in Column G does your data start on (that's actual data, not headers if any)?

[MATRIXOFFICE]

thanks Rick

sheet names are each month so there are 12 sheets containing data in this case JAN FEB MAR etc etc

Data commences in row 5 down to row 150

[Rick Rothstein]

sheet names are each month so there are 12 sheets containing data in this case JAN FEB MAR etc etc

Data commences in row 5 down to row 150

Okay, I did not understand we were talking multiple sheets as well. One more question then. Given each sheet is devoted to a month, is there a need to check every sheet every time the workbook is closed? In other words, would there be any entries for the MAR (and beyond) sheet(s) yet? Also, would there be any entries for months prior to the current month? For example, tomorrow is February 1st... when this workbook is opened on February 1st, would there be any need to check the JAN sheet when it is closed later that day? Please answer both of those questions.

[MATRIXOFFICE]

no its all point in time data capture. there is no need to check past sheets only current sheets in use. there are no future entries as the data
is based on incidents that occur. we do not know when and what they are of course ..

[MATRIXOFFICE]

Rick any further advice on this problem?

[MATRIXOFFICE]

Bump## anymore t houghts on this Rick?