Personal.xls & Workbook_BeforeClose

[William]

Hi

Can anyone explain why the "Workbook_BeforeClose" event does not work with
the "Personal.xls" file.

The code below is in the "ThisWorkBook" module of the Personal.xls file.

'This works fine
Private Sub Workbook_Open()
MsgBox "Opening"
End Sub

'This does not work
Private Sub Workbook_BeforeClose(Cancel As Boolean)
MsgBox "Closing"
End Sub
'(This does work however if Personal.xls is not closed at the same time as
the Excel application.)



Thanks
--

XL2003
Regards

William
(e-mail address removed)

 

[Tom Ogilvy]

It works fine for me.

Are you sure you saved personal.xls after making the change and before you
tried to close it?