Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do the Addins belong to a workbook, or are they global to all workbooks loaded?
Faustino,
The AddIns collection is a property of the Application object, so you can think of them as global to all workbooks loaded. It is a design flaw that the option is disabled when no documents are loaded. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "faustino Dina" wrote in message ... Hi, Is the Addins list accesible from the Tool menu, local to the loaded document, or is it a global property for all the documents to be loaded in the PC? I'm asking that 'cause this property is disabled when there are no documents loaded in Excel... Thanks in advance Faustino |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do the Addins belong to a workbook, or are they global to all workbooks loaded?
So every Excel Application would carry the baggage of all AddIns that
are checked, even if they don't require them? Thank you. DJ Faustino, The AddIns collection is a property of the Application object, so you can think of them as global to all workbooks loaded. It is a design flaw that the option is disabled when no documents are loaded. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do the Addins belong to a workbook, or are they global to allworkbooks loaded?
Every Excel Application sounds like you're opening more than one instance of
excel. But if you don't want an addin enable, just toggle it off. When you need it, toggle it back on. Personally, I always keep both analysis toolpaks open (worksheet and VBA addins)--nothing more until I need it. And I try to open all my workbooks in a single instance of excel. DJ wrote: So every Excel Application would carry the baggage of all AddIns that are checked, even if they don't require them? Thank you. DJ Faustino, The AddIns collection is a property of the Application object, so you can think of them as global to all workbooks loaded. It is a design flaw that the option is disabled when no documents are loaded. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
group workbooks/files to make global changes? | New Users to Excel | |||
I am protecting my workbook, but it is broken when it is loaded by Quatro Pro, please help | Excel Discussion (Misc queries) | |||
How do I perform a global change within/across Excel workbooks? | Excel Discussion (Misc queries) | |||
How to change the order in which excel addins gets loaded? | Excel Discussion (Misc queries) | |||
Global Setting For All Workbooks - Filename In Footer | Excel Worksheet Functions |