I know how to install an addin (e.g.
application.AddIns.Add("myaddin.xla",TRUE))

I also know how to install & un-install (Addin.Instal(TRUE)) - equivalent to
checking/unchecking the entry in Tools/Add-Ins dialog.

How do I completely remove an add-in so that it no longer gets listed in the
Tools/Add-Ins dialog ?

Many thanks

Steve Kearon

Hi Steve

Uncheck the Add-in in ToolsAdd-ins
Close Excel
Remove the Add-in from the Library folder(or other folder)
Open excel
Go to ToolsAdd-ins and click on the Add-in name

Click Yes to delete it



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Steve Kearon" wrote in message ...
I know how to install an addin (e.g.
application.AddIns.Add("myaddin.xla",TRUE))

I also know how to install & un-install (Addin.Instal(TRUE)) - equivalent to
checking/unchecking the entry in Tools/Add-Ins dialog.

How do I completely remove an add-in so that it no longer gets listed in the
Tools/Add-Ins dialog ?

Many thanks

Steve Kearon

Hi Steve,

You can remove the value corresponding to the add-in you wish to remove from
the following registry key (Excel 2002):

HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\E xcel\Add-in Manager

When an add-in is uninstalled (unchecked from add-ins list), the full path
to the add-in is added as a string (REG_SZ) value to the above key. That
way, Excel will keep it in the list of "installable" add-ins, and when you
recheck it, Excel will know where the add-in is located. Once the add-in is
uninstalled, the string value will be added. However, this seems to happen
only after Excel is closed the first time after uninstalling the add-in. So
once you've removed (unchecked) the add-in, you'll have to close Excel, then
remove the string value associated with that add-in from the above key.

Earlier versions of Excel will have similar keys, but they will be named
slightly differently.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Steve Kearon wrote:
I know how to install an addin (e.g.
application.AddIns.Add("myaddin.xla",TRUE))

I also know how to install & un-install (Addin.Instal(TRUE)) -
equivalent to checking/unchecking the entry in Tools/Add-Ins dialog.

How do I completely remove an add-in so that it no longer gets listed
in the Tools/Add-Ins dialog ?

Many thanks

Steve Kearon

uuuuuuuuuuuuuuuummmmmmmmmmmmmmmmmmmmm

yeah ...

but how do I do it programmatically (no user intervention) ?

thanks anyway

"Ron de Bruin" wrote in message
...
Hi Steve

Uncheck the Add-in in ToolsAdd-ins
Close Excel
Remove the Add-in from the Library folder(or other folder)
Open excel
Go to ToolsAdd-ins and click on the Add-in name

Click Yes to delete it



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Steve Kearon" wrote in message
...
I know how to install an addin (e.g.
application.AddIns.Add("myaddin.xla",TRUE))

I also know how to install & un-install (Addin.Instal(TRUE)) -
equivalent to
checking/unchecking the entry in Tools/Add-Ins dialog.

How do I completely remove an add-in so that it no longer gets listed in
the
Tools/Add-Ins dialog ?

Many thanks

Steve Kearon

OK, thanks

"Jake Marx" wrote in message
...
Hi Steve,

You can remove the value corresponding to the add-in you wish to remove
from
the following registry key (Excel 2002):

HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\E xcel\Add-in Manager

When an add-in is uninstalled (unchecked from add-ins list), the full path
to the add-in is added as a string (REG_SZ) value to the above key. That
way, Excel will keep it in the list of "installable" add-ins, and when you
recheck it, Excel will know where the add-in is located. Once the add-in
is
uninstalled, the string value will be added. However, this seems to
happen
only after Excel is closed the first time after uninstalling the add-in.
So
once you've removed (unchecked) the add-in, you'll have to close Excel,
then
remove the string value associated with that add-in from the above key.

Earlier versions of Excel will have similar keys, but they will be named
slightly differently.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Steve Kearon wrote:
I know how to install an addin (e.g.
application.AddIns.Add("myaddin.xla",TRUE))

I also know how to install & un-install (Addin.Instal(TRUE)) -
equivalent to checking/unchecking the entry in Tools/Add-Ins dialog.

How do I completely remove an add-in so that it no longer gets listed
in the Tools/Add-Ins dialog ?

Many thanks

Steve Kearon