View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff[_2_] Harald Staff[_2_] is offline
external usenet poster
 
Posts: 449
Default Run macro before closing Excel 2007

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