Workbook_beforeClose not working in add-in?

[muffins]

I've the following code in my add-in. Strangely the code in the Workbook_Open event executes as expected, but not the Workbook_beforeClose event. May I know the reason?

thank you very much.

*********************************************

Private Sub Workbook_Open()
msgbox "hi!"
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
msgbox "bye!"
End Sub

 

[muffins]

actually my macro is simple.. to add a customised menu to workbook A and remove the menu when the workbook is closed so that the menu will not be shown when other workbooks are opened.

That is to say, i hope the add-in will be closed when workbook A is closed, and loaded when workbook A is opened.
This message was edited by muffins on 2002-11-06 04:04

 

[Andrew Poulsom]

You could either:

1. Put all the code to add and remove the customised menu in workbook A, or

2. Close the Add-In in the Workbook_BeforeClose event procedure in workbook A.

 

[Tournifreak]

I've the following code in my add-in. Strangely the code in the Workbook_Open event executes as expected, but not the Workbook_beforeClose event. May I know the reason?

thank you very much.

*********************************************

Private Sub Workbook_Open()
msgbox "hi!"
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
msgbox "bye!"
End Sub

The problem is that you need to install the service pack for Excel 2000.
http://support.microsoft.com/kb/q248172/

Jon.