Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
invisible Add-ins in Excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
invisible Add-ins in Excel
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
invisible Add-ins in Excel
Użytkownik "Peter T" <peter_t@discussions napisał w wiadomości
... 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
invisible Add-ins in Excel
"Adax" wrote in message
... Użytkownik "Peter T" <peter_t@discussions napisał w wiadomości ... 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? 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\Ex cel\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\Ex cel\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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run Microsoft Query when Excel is invisible | Excel Programming | |||
Confusing Invisible Excel Sheet | Excel Discussion (Misc queries) | |||
In excel, why do web links become invisible? | Excel Discussion (Misc queries) | |||
excel document is invisible | Excel Discussion (Misc queries) | |||
Excel Workbook Invisible | Excel Programming |