| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
unload an add-in from an Macro
sure we can enable a macro by click tools=add-ins=click addin name an ok But does any Excel expert here knows how can I unload the add-ins fro a vba macro? Thanks :cool -- lang047 ----------------------------------------------------------------------- lang0477's Profile: http://www.excelforum.com/member.php...fo&userid=2397 View this thread: http://www.excelforum.com/showthread.php?threadid=37597 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
unload an add-in from an Macro
addins("myAddin").installed=false
-- HTH Bob Phillips "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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
unload an add-in from an Macro
Good afternoon lang0477 This should do the trick: Sub Remove_Add-In() On Error Resume Next AddIns("MyAdd-In").Installed = False End Sub Short and sweet. HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=375972 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
unload an add-in from an Macro
excellent, thanks guys : -- lang047 ----------------------------------------------------------------------- lang0477's Profile: http://www.excelforum.com/member.php...fo&userid=2397 View this thread: http://www.excelforum.com/showthread.php?threadid=37597 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unload all addins in VBA | Excel Programming | |||
| Unload the form on esc key | Excel Programming | |||
| form won't unload | Excel Programming | |||
| "Unload" selection after running macro? | Excel Programming | |||
| Unload Me | Excel Programming | |||
![lang0477[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
