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