Add-In Manager

  • Thread starter Thread starter dan
  • Start date Start date
D

dan

Win XP
Excel XP

I am making a custom menu item that automatically inserts
certain Worksheet Templates for pulling #'s into such
as "Table" "Bar" "Pie" etc. At first a had all my macros
in a (HIDDEN) Personal.xls file. But now I am trying to
have them in an add-in file I have made one and have a
few ?'s.

Why can't I see any add-ins in my VBA Add-in Manager when
they are visible in the Project Explorer? I want to make
it load on startup if it is not.

Will the Add-In affect performance (its small)? I made
a "Disable" menu item in my "INSERTWORKSHEETS" menu that
de-activated the macros by closing the Personal.xls and
Dimming the Menu item. Do I need to worry about this
with an add-in?
 
To tell Excel to load an add-in during startup:

1. Start Excel.
2. Select Add-Ins from the Tools menus.
3. In the Add-ins dialog box , locate the add-in you want to load at startup and check the checkbox next to it.

If that add-in is not in the list, click "Browse", and locate it in your hard drive, and press OK. That add-in should then appear in the list.

4. Click OK to close the Add-Ins dialog box.
 
I meant the ADD-INS/MANAGER menu item in Visual Basic, it
does not have a browse, I've given the project a name as
an add-in, but it does not show, same with the other add-
ins I have installed.

I'm worried if the add-in somehow becomes unactive or
deleted, the people i work with are to retarded to figure
out how to do the 3 steps below.
-----Original Message-----
To tell Excel to load an add-in during startup:

1. Start Excel.
2. Select Add-Ins from the Tools menus.
3. In the Add-ins dialog box , locate the add-in you
Click to expand...
want to load at startup and check the checkbox next to it.
If that add-in is not in the list, click "Browse", and
Click to expand...
locate it in your hard drive, and press OK. That add-in
should then appear in the list.
 
Back
Top