You only do Tools-Add Ins-Install once, thereafter the add-in is always
loaded when Excel loads, unless someone uninstalls it.

The other way (not my choice) is to put it in the XLSTart directory.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"dutty" wrote in message
...
I'm working on a "calculator" program that my company wants to distribute
to
customers. They chose to have me create this as an add-in to Excel.

If I save a workbook with VB code as an add-in, how do I get it to be
loaded
every time I open Excel?

In greater detail--I have a workbook that I've got some code in it to add
a
menu to the title bar, but I want it to be there every time I open Excel,
not
have to go to Tools-Add Ins-Install every time in order to get the menu
to
appear.

How do I structure this so that it can be installed on any machine?

(I'm using XP, Excel 2002)