Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
event failing
Have the following code works most of the time. On occasion will not trigger
and asks if you want to save changes. Do not understand why this occionsial failure. Thanks for looking Heres code Private Sub Workbook_BeforeClose(cancel As Boolean) 'Call catsheetdel UserForm3.Show False Call catsheetdel DoEvents UserForm3.Hide ThisWorkbook.Save End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
event failing
Generally this is because you have disabled events (whether you meant to or
not). Events are enabled at the application level, so if they have been disabled, they are disabled for the whole Excel application. -- Regards, Tom Ogilvy "Curt" wrote: Have the following code works most of the time. On occasion will not trigger and asks if you want to save changes. Do not understand why this occionsial failure. Thanks for looking Heres code Private Sub Workbook_BeforeClose(cancel As Boolean) 'Call catsheetdel UserForm3.Show False Call catsheetdel DoEvents UserForm3.Hide ThisWorkbook.Save End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF statement failing | Excel Programming | |||
COUNTA failing? | Excel Discussion (Misc queries) | |||
My formulas are failing! | Excel Discussion (Misc queries) | |||
Link 'failing' | Links and Linking in Excel | |||
Userform_Initialize event failing to be called | Excel Programming |