Your add-in needs some Workbook_Open event code in Thisworkbook module or
Auto_Open code in a general module.

The code will build the Toolbar.

Don't forget to delete the Toolbar when the add-in closes.

See Debra Dalgleish's site for sample by Dave Peterson.

http://www.contextures.on.ca/xlToolbar02.html


Gord Dibben MS Excel MVP


On Fri, 11 Dec 2009 14:34:11 -0500, "Todd Heiks"
<Todd.Heiks_AT_NoSpam_GreatLakesWindow.com wrote:

How do i make my addin run when it is added to excel?
I want the user to browse to my addin and then have the addin build the
toolbar for itself.

Regards,
Todd