Hi group

How do I with vba remove add in from inactive list of add ins.
I have uninstalled the add in but it still appears in inactive list

Cheers

If the addin is in the default addins folder remove the addin (don't just
rename it).

If the addin is in some other location, remove or rename the addin. Restart
Excel, attempt to re-install the addin in the addin manager dialog, ie tick
the box. A message will say the addin is not found and ask if you want to
remove it from the list, click yes.

Regards,
Peter T

"Teddy" wrote in message
...
Hi group

How do I with vba remove add in from inactive list of add ins.
I have uninstalled the add in but it still appears in inactive list

Cheers

On 5 Mar., 13:01, "Peter T" <peter_t@discussions wrote:
If the addin is in the default addins folder remove the addin (don't just
rename it).

If the addin is in some other location, remove or rename the addin. Restart
Excel, attempt to re-install the addin in the addin manager dialog, ie tick
the box. A message will say the addin is not found and ask if you want to
remove it from the list, click yes.

Regards,
Peter T

"Teddy" wrote in message

...



Hi group

How do I with vba remove add in from inactive list of add ins.
I have uninstalled the add in but it still appears in inactive list

Cheers- Skjul tekst i anførselstegn -

- Vis tekst i anførselstegn -

Is there a way to do this by VBA?

If the addin is in a default addins folder simply use the Name method to
move the file into a different folder.

If the addin is elsewhere the only programmatic way is to delete the entry
from this key in the registry -

HKEY_CURRENT_USER\Software\Microsoft\Office\versio n\Excel\Add-in Manager

(assuming it was uninstalled last Excel session)

Regards,
Peter T


"Leon" wrote in message
...

Is there a way to do this by VBA?


On 5 Mar., 13:01, "Peter T" <peter_t@discussions wrote:
If the addin is in the default addins folder remove the addin (don't just
rename it).

If the addin is in some other location, remove or rename the addin.
Restart
Excel, attempt to re-install the addin in the addin manager dialog, ie
tick
the box. A message will say the addin is not found and ask if you want to
remove it from the list, click yes.

Regards,
Peter T

"Teddy" wrote in message

...



Hi group

How do I with vba remove add in from inactive list of add ins.
I have uninstalled the add in but it still appears in inactive list

Cheers- Skjul tekst i anførselstegn -

- Vis tekst i anførselstegn -

If you have deleted the addin & want to remove it from the addin manager
list, only way I know to do this is to use sendkeys to imitate user doing
this manually.

Try this procedure & see if it will do what you are looking for:


Sub CleanAddinList()
Dim AddinCount As Long
Dim GoUpandDown As String
'Turn display alerts off so user is
'not prompted to remove Addin from list
With Application
.DisplayAlerts = False

Do
'Count of all AddIns
AddinCount = Application.AddIns.Count

'Create string for SendKeys that will move up & down
'AddIn Manager List
'Any invalid AddIn listed will be removed
GoUpandDown = "{Up " & AddinCount & "}{DOWN " & AddinCount & "}"

Application.SendKeys GoUpandDown & "~", False
Application.Dialogs(xlDialogAddinManager).Show

'Continue process until all invalid AddIns are removed
'code will only remove one at a time.
Loop While AddinCount < Application.AddIns.Count
.DisplayAlerts = True

End With
End Sub

hope helpful
--
jb


"Teddy" wrote:

Hi group

How do I with vba remove add in from inactive list of add ins.
I have uninstalled the add in but it still appears in inactive list

Cheers

On 5 Mar., 14:00, "Peter T" <peter_t@discussions wrote:
If the addin is in a default addins folder simply use the Name method to
move the file into a different folder.

If the addin is elsewhere the only programmatic way is to delete the entry
from this key in the registry -

HKEY_CURRENT_USER\Software\Microsoft\Office\versio n\Excel\Add-in Manager

(assuming it was uninstalled last Excel session)

Regards,
Peter T

"Leon" wrote in message

...

Is there a way to do this by VBA?

On 5 Mar., 13:01, "Peter T" <peter_t@discussions wrote:



If the addin is in the default addins folder remove the addin (don't just
rename it).

If the addin is in some other location, remove or rename the addin.
Restart
Excel, attempt to re-install the addin in the addin manager dialog, ie
tick
the box. A message will say the addin is not found and ask if you want to
remove it from the list, click yes.

Regards,
Peter T

"Teddy" wrote in message

...

Hi group

How do I with vba remove add in from inactive list of add ins.
I have uninstalled the add in but it still appears in inactive list

Cheers- Skjul tekst i anførselstegn -

- Vis tekst i anførselstegn -- Skjul tekst i anførselstegn -

- Vis tekst i anførselstegn -

Great thanks

On 5 Mar., 14:28, john wrote:
If you have deleted the addin & want to remove it from the addin manager
list, only way I know to do this is to use sendkeys to imitate user doing
this manually.

Try this procedure & see if it will do what you are looking for:

Sub CleanAddinList()
* * Dim AddinCount As Long
* * Dim GoUpandDown As String
* * 'Turn display alerts off so user is
* * 'not prompted to remove Addin from list
* * With Application
* * * * .DisplayAlerts = False

* * * * Do
* * * * * * 'Count of all AddIns
* * * * * * AddinCount = Application.AddIns.Count

* * * * * * 'Create string for SendKeys that will move up & down
* * * * * * 'AddIn Manager List
* * * * * * 'Any invalid AddIn listed will be removed
* * * * * * GoUpandDown = "{Up " & AddinCount & "}{DOWN " & AddinCount & "}"

* * * * * * Application.SendKeys GoUpandDown & "~", False
* * * * * * Application.Dialogs(xlDialogAddinManager).Show

* * * * * * 'Continue process until all invalid AddIns are removed
* * * * * * 'code will only remove one at a time.
* * * * Loop While AddinCount < Application.AddIns.Count
* * * * .DisplayAlerts = True

* * End With
End Sub

hope helpful
--
jb



"Teddy" wrote:
Hi group

How do I with vba remove add in from inactive list of add ins.
I have uninstalled the add in but it still appears in inactive list

Cheers- Skjul tekst i anførselstegn -

- Vis tekst i anførselstegn -

Really great :-D

Can I ask you guys if you know a way to install and NOT having a
dialogbox showing up asking if I want to copy to my user folder.
The answer should here be NO. (i don't want to copy)