validation

[Guest]

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.

 

[Guest]

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:

 

[Guest]

Thanks Stefi, it helped!

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:

 

[Guest]

Your feedback is appreciated!
Regards,
Stefi


„Minerva†ezt írta: