Add-In to load when Excel opens?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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?
Click to expand...

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.
Click to expand...

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?
Click to expand...

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
 
Put it in the addins directory,

then do Tools=>Addins, and put a check next to your addin. Then it should
load each time excel is opened.
 
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)
 
Back
Top