Here is another article or two you might find useful:
http://msdn.microsoft.com/library/ba...n_addins97.htm
http://msdn.microsoft.com/library/of...exceladdin.htm
http://www.microsoft.com/exceldev/tips/addins.htm
These are about distributing applications

to call a macro in an addin you have to use application.Run

Application.Run "Myaddin.xla!Macro1"

If you create a reference from the workbook to the addin (tools=References
in the VBE) you can call the Macro as if it was contained in that workbook.

--
Regards,
Tom Ogilvy

"Kanan" wrote in message
...
hi,
I have 7 subroutines that are common in my 10 different workbooks. In
other
words, the vba code is the same in all workbooks. Is it possible to
create
an add-in
type so that I don't have this code in each workbook? If yes, pls let me
know the
exact steps. I tried the add-in . But I encountered 'unknown sub error '
in
my workbook where I was calling the subroutine from the add-in.

thanks
Kanan