See Inserting a Button and a Macro in and excel file
HTH,
In reply to Re: How to write Excel Addin functions!! by planetscape in thread How to write Excel Addin functions!! by haxman