Adax said:
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