Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy workbook- Validation function | Excel Worksheet Functions | |||
TWO QUESTIONS: Validation & Spacing...PLEASE HELP | Excel Discussion (Misc queries) | |||
data validation lists | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Data Validation Window? | Excel Discussion (Misc queries) |