View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default unload an add-in from an Macro

From help on the Installed property of the addin object:

Set a = AddIns("Solver Add-In")
If a.Installed = True Then
MsgBox "The Solver add-in is installed"
Else
MsgBox "The Solver add-in is not installed"
End If

so set the installed property to false

--
Regards,
Tom Ogilvy


"lang0477" wrote in
message ...

sure we can enable a macro by click tools=add-ins=click addin name and
ok
But does any Excel expert here knows how can I unload the add-ins from
a vba macro?
Thanks


--
lang0477
------------------------------------------------------------------------
lang0477's Profile:

http://www.excelforum.com/member.php...o&userid=23975
View this thread: http://www.excelforum.com/showthread...hreadid=375972