The WorkbookBeforeClose is an application level event in my com addi
with the following signatur

Private Sub Excel_WorkbookBeforeClose(ByVal Wb As Excel.Workbook
Cancel As Boolean)

Wb.Save

End Sub



Calling the Wb.Save should save the workbook, but it didn't

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com