Load/Unload Addin when Workbooks Open/Close

[bartrein]

Hi

It is probably a common question and i had done some research before posting however what i have found does not seem to work for me.

So the situation is :
- I have created a library of some reusable VBA functions/subs and stored it in .XLA addin, at the moment they are only to be used in VBa code not in worksheet cells

- I have couple of files which have references to my library (references in VBE)

- When one of these files open it automatically opens my ADDIn (Addin is hidden thisworkbook.isaddin = true)

I am happy with everything up to this point however after i close one the file that have reference to my addin,
I still see the ADDIN in the Project Explorer in VBE , and the functions in the list of User Defined Functions. What's even more interesting i still see the file that has reference to my Addin in VBE window.

The only way of closing/hiding the Addin functions is to close and open again Excel.

I thought that

Application.AddIns(sAddinName).Installed = False/True

would take care of showing/hiding the addin functions but that does not seem to be the case.

Any suggestions?

Many thanks

 

[bartrein]

Anyone?