"tk" ha scritto nel messaggio
...
Is there an event that fires when a workbook is saved or closed. I have
tried adding workbook_save and workbook_close functions (to the
thisworkbook
object), but the code that I put in never fires. The workbook_open seems
to
work ok. I am using Excel 2003.

Thanks,



I don't understand. I have the following code and work fine:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
MsgBox ("Your Workbook is in order to be closed")
End Sub

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
MsgBox ("Your Workbook is in order to be saved")
End Sub

--
Ciao
Thunder