how to completely remove an add-in?

  • Thread starter Thread starter Steve Kearon
  • Start date Start date
S

Steve Kearon

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 Tools>Add-ins
Close Excel
Remove the Add-in from the Library folder(or other folder)
Open excel
Go to Tools>Add-ins and click on the Add-in name

Click Yes to delete it
 
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\Excel\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]
 
uuuuuuuuuuuuuuuummmmmmmmmmmmmmmmmmmmm

yeah ...

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

thanks anyway
 
OK, thanks

Jake Marx said:
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\Excel\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 said:
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
Click to expand...
Click to expand...
 
Back
Top