I am learning about Add ins and have found quite a bit in this group.
I could however not find anything explaining the following:

I learned that Add Ins must be "added" and "installed", but sometimes
it might also have to be loaded in order to take effect. I have a few
add ins that are available everytime I open Excel, but these are not
"loaded" (opened) each time - they were installed some time ago. So
does Excel remember the add ins from the previous time it was loaded
or is there an entry made in a register when the add in is
"installed"? Does Excel then refer to the register to see which Add
Ins must be "loaded" when opening the application?

Also, could someone point me in the direction of some useful sites
where I can learn more?

See Jan Karel Pieterse's tutorial at:

http://www.jkp-ads.com/Articles/DistributeMacro00.htm

http://support.microsoft.com/?id=167909
XL: Securing Visual Basic Code in Microsoft Excel

http://support.microsoft.com/?id=156942
XL97: How to Create an Add-in File in Microsoft Excel 97

http://support.microsoft.com/?id=211563
How to create an add-in file in Excel 2000

http://msdn.microsoft.com/library/en...xceladdins.asp

http://msdn.microsoft.com/library/en...exceladdin.asp

http://www.j-walk.com/ss/excel/tips/tip45.htm
Excel 97: Creating Add-Ins

The list of addins is stored in the registry. Do a goggle groups search of
this group using Addins and Registry

--
Regards,
Tom Ogilvy

"KobusD" wrote:

I am learning about Add ins and have found quite a bit in this group.
I could however not find anything explaining the following:

I learned that Add Ins must be "added" and "installed", but sometimes
it might also have to be loaded in order to take effect. I have a few
add ins that are available everytime I open Excel, but these are not
"loaded" (opened) each time - they were installed some time ago. So
does Excel remember the add ins from the previous time it was loaded
or is there an entry made in a register when the add in is
"installed"? Does Excel then refer to the register to see which Add
Ins must be "loaded" when opening the application?

Also, could someone point me in the direction of some useful sites
where I can learn more?

Can be found here in registry.

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Options

Right-side window shows OPEN, OPEN1, OPEN2 etc.


Gord Dibben MS Excel MVP


The list of addins is stored in the registry. Do a goggle groups search of
this group using Addins and Registry