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

 

[Richie(UK)]

Hi Muffins,

Have a look here for an Auto_Close option:

http://groups.google.com/groups?hl=...TF-8&selm=3abf302d%241%40news.datev.de&rnum=1

Or here for an Application Level Events option:

http://groups.google.com/groups?hl=...selm=%23JJ6AvZ9AHA.1940%40tkmsftngp07&rnum=10

HTH

EDIT : Added second link.
_________________<font color="blue"> «««<font color="red">¤<font color="blue"><font size=+1>Richie</font><font color="red">¤<font color="blue"> »»»</font>

</gif>
This message was edited by Richie(UK) on 2002-11-05 05:29

 

[muffins]

Auto_close is an application level event, what if I want to place my code at the WorkBook level? eg my add-in will create a menu when workbook opens and delete the menu when the workbook is closed.
This message was edited by muffins on 2002-11-06 00:53

 

[Andrew Poulsom]

Auto_Close in not an application level event. It will work just like Workbook_BeforeClose if placed in a general module in your Add-In.

 

[muffins]

thanks but i've tried and it just didnt delete my menu upon workbook closing; my code in Auto_Close did not execute.. =(

 

[Andrew Poulsom]

How are you closing the Add-In?

 

[muffins]

i didn't close the add-in. how shld i do it programatically?

thank you for your patience..

 

[Andrew Poulsom]

I thought so.

Workbooks("MyAddin.xla).Close

You may then find that your original Workbook_BeforeClose event procedure will work.

 

[muffins]

i see... but where do i place this piece of code?

thank you very much.

 

[Andrew Poulsom]

That depends. What is the purpose of your Add-In and when do you wish to close it?