Hi Dutty,
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?
By checking the addin in Tools, addins, as you say you have.
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.
Place a call to the code that sets up the menu in the Thisworkbook module, using
the Workbook_Open event, not the AddinInstall event.
How do I structure this so that it can be installed on any machine?
Download e.g. my Name Manager from
www.jkp-ads.com/Download.htm
It contains a setup file inside the zip file you can modify at will to use for
installation of your own addin.
Regards,
Jan Karel Pieterse
Excel MVP
www.jkp-ads.com