workbook before close for error checking

[clng]

Dear all,

I am writing some macro to test whether the summation in sheet5 and sheet7 summ up to zero (both also in their respective worksheet code) using worksheet deactivate.

this works wells when they try to switch to other worksheets, the macro will prompt them the error in summation and switch them back to that particular worksheet.

however, this error checking could not be extended when they immediately close the workbook without switching worksheets.

hence, I tried to include the same code in "Thisworkbook" code window but the workbook will continue to close even with the error prompt.
And i have 2 worksheets that needs to do the error check (i had both using cells instead of range so that I can do some offset and counting) and the "cell" usage is making me confused as to tell the macro which worksheet of those cells am i referring to.....

please help to provide some alternatives.

Thanks in advance.

Cheers,
CL