Lasse
Turn your Personal.xlsb into MyAddin.xlam, and install it, for the desired
behavior.
HTH. Best wishes Harald
"Lasse" wrote in message
...
Hi again
I have tried the code you suggest but if I put it in Workbook_BeforeClose
it
will remove the add-in if just the active workbook is closed, I only want
it
to remove the add-in if Excel is closed.
If a user opens a workbook and then wants to close it without closing
Excel
so he/she can open a new workbook the add-in has to be present.
/Lasse
"The Code Cage Team" wrote:
Perhaps something like:
If AddIns("YOUR Add-in").Installed = True Then
AddIns("YOUR Add-in").Installed = False
End If
--
The Code Cage Team
Regards,
The Code Cage Team
www.thecodecage.com
------------------------------------------------------------------------
The Code Cage Team's Profile:
http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=6952