Your feedback is appreciated!
Regards,
Stefi


€žMinerva€� ezt Ã*rta:

Thanks Stefi, it helped!

"Stefi" wrote:

Hi Minerva,

Try to apply a
Private Sub Workbook_BeforeClose(Cancel As Boolean)
event macro, and set Cancel to True if one of the conditions is not met
during the validation.

Regards,
Stefi


€žMinerva€� ezt Ã*rta:

Hi,
I am validating a set of conditions before the end user closes the excel
window, the validation does go on afterwhich the window closes - even if a
set of conditions has not been met. I want the user to be unable to close the
window when he tries to; if one of the conditions is not met during the
validation.
Thanks.