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

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

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

Do the Addins belong to a workbook, or are they global to all workbooks loaded?
 

DJ

If your macros are in an Add-in, the enable/disable prompt will not come up.

Place your macros and functions in a workbook then save as file type Microsoft
Excel Add-in(*.xla)

You can store it in Office\Library and have it checked to be loaded through
ToolsAdd-in or you can store it in your XLSTART folder to be loaded when
Excel starts up.

I haven't used a Personal.xls for quite a while, but I believe if you load it
from XLSTART folder, you will not get the warning.

Gord Dibben Excel MVP - XL97 SR2 & XL2002


On 6 Aug 2003 10:02:08 -0700, (DJ) wrote:

Is there a location where I can put my personal macros or modules so
they would be available to all workbooks --- I guess that would be an
Add-In, wouldn't it?

Is there a way to identify my personal macros or modules as safe and
to eliminate that enable/disable prompt? Why don't I get any
enable/disable prompts when the analysis toolpaks is checked?