Thread: event failing
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Curt Curt is offline
external usenet poster
 
Posts: 469
Default 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