View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
DJ DJ is offline
external usenet poster
 
Posts: 1
Default 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