Addin Disappear

[jbesclapez]

Hello MrExcel!

I installed an addin like you advised me in order to run some macros.
When i open excel 2007, the addin starts OK (it is activated by default).
However, for an unknown reason it disappear when i run the macro from the addin.

Please could you help me troubleshooting that?
It is really tricky and i dont know what to give you for information....

Thanks for your help

 

[jbesclapez]

I realize i have to be a bit more precise.
The addin disappear from the QAT

 

[jbesclapez]

Mr Excel,
I investigated and i think i found where it bugs.
To find that i did a step by step ...

here is the code in the Addin that makes it to close... but why?
So i think the problem does not come from my macro but from the Addin?
What is your opinion?

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    Call WBRemovePopUp
End Sub

Sub WBRemovePopUp()
    On Error Resume Next
    Application.CommandBars(ThisWorkbook.Sheets("MenuSheet").Range("B2").Value).Delete
    On Error GoTo 0
End Sub

 

[jbesclapez]

Sorry... the problem could come from this line that calls a macro within the addin...

Sub OtherReport()
Application.Run ("NAddin.xlam!Macro1")
End Sub

But what am i doing wrong??

I am just calling a macro in the addin