validation

M

Minerva

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.
 
S

Stefi

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:
 
M

Minerva

Thanks Stefi, it helped!

Stefi said:
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:
Click to expand...
 
Top