| 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) | |||
Hybrid Mode
