Hi,
Anyone knows how to remove an add-in from the list of add-ins (Tools
AddIns) in Excel?

Sam



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Sam,

The simplest way manually is to delete or move the file that the add-in in
the list is pointing to while Excel is not running. Next time you try and
load the add-in Excel will say it can't find it and prompt to remove from
the list.

If it is in your add-ins folder move it out.

The more complex way is to look in the registry under the following keys

HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\E xcel\Options
where you will need to rename the OPENn keys if you remove one with another
above it so that they remain contiguous.

and

HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\E xcel\Add-in Manager
where I think you can just delete them.

To do it in code is tough since you need to access the registry directly and
deal with renaming the OPENn values.

Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in


"samdesilva" wrote in message
...
Hi,
Anyone knows how to remove an add-in from the list of add-ins (Tools
AddIns) in Excel?

Sam



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Thanks, manually removing from the registry works.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Sam,

Another way to remove addins programatically is:
AddIns("My Add-In").Installed = False

Substitute the name of your add-in with "My Add-In".

Jack

"samdesilva" wrote in message
...
Hi,
Anyone knows how to remove an add-in from the list of add-ins (Tools
AddIns) in Excel?

Sam



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Jack,

Correct in that the installed = false will unload it, but it will not remove
it from the list of add-ins. The question on how to actually get it off the
list features here a lot.

Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in


"Jack" wrote in message
news:BjNeb.10249$Rd4.6082@fed1read07...
Sam,

Another way to remove addins programatically is:
AddIns("My Add-In").Installed = False

Substitute the name of your add-in with "My Add-In".

Jack

"samdesilva" wrote in message
...
Hi,
Anyone knows how to remove an add-in from the list of add-ins (Tools
AddIns) in Excel?

Sam



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/