invisible Add-ins in Excel

[Adax]

Hello! Please help me about add-ins in Excel 2003.
I have one add-ins, wich is invisible in the Add-ins dialog box and
question:
how remove this invisible in the Add-ins dialog box Add-ins?
How way is loaded this invisible Add-ins? Thanks a lot in advance for your
helps, Adax

 

[Peter T]

If the Addin is an .xla Workbook and if it is in the Addin's collection it
will be visible in the Addins dialog. You can have an xla Addin loaded but
not in the Addins collection, if so it will not appear in the dialog.

Sometimes an Addin can be in the Addins collection but not Installed and not
visible in the dialog. That can occur if the Addin is not in one of the
default Addin Paths, however that is not what you are describing (in that
situation the only way to remove it is via the registry).

 

[Adax]

If the Addin is an .xla Workbook and if it is in the Addin's collection
it will be visible in the Addins dialog. You can have an xla Addin
loaded but not in the Addins collection, if so it will not appear in
the dialog. Sometimes an Addin can be in the Addins collection but not
Installed and not visible in the dialog. That can occur if the Addin is
not in one of the default Addin Paths, however that is not what you are
describing (in that situation the only way to remove it is via the
registry).

Thanks! And next question:
how to add an Addin to Excel in this invisible way in collection?
Is it possible to write VBA code in Excel for remove and add invisible
Addin?

 

[Peter T]

Thanks! And next question:
how to add an Addin to Excel in this invisible way in collection?
Is it possible to write VBA code in Excel for remove and add invisible
Addin?

In theory you can add an Addin to the collection so that it doesn't appear
in the dialog but only as an un-installed addin. However there is not point,
un-installed means it will not load automatically.

You can do this in one of two ways
- Ensure the addin is not in one of the two Addin folders
- Install the addin
- Uninstall the addin
or
add the full path in this registry key
HKEY_CURRENT_USER\Software\Microsoft\Office\X.0\Excel\Add-in Manager
(see other un-installed addins in that key)

All installed addins (addins that will load at start-up and irrespective of
which folder) are in this key
HKEY_CURRENT_USER\Software\Microsoft\Office\X.0\Excel\Options

"X.0" refers to the version, eg 11.0 for Excel 2003

(very slightly different in Excel97)

If you don't want your addin in the addins collection at all you could put
it in the start folder, or load it in the open event or button click of
another installed addin or Personal.

Regards,
Peter T