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
|