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,

Workbook_BeforeSave
Workbook_BeforeClose

If you are at the ThisWorkbook's code page, you will see at the top of
the window two drop-down boxes. At first, in an empty module, the left
one says: (General). If you choose ThisWorkbook instead, then the right
box will contain all the workbook-level event procedures.

HTH
Kostis Vezerides

"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