ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Add-In Manager (https://www.excelbanter.com/excel-programming/282387-add-manager.html)

dan

Add-In Manager
 
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?

Edwin Tam (MS MVP)

Add-In Manager
 
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.


No Name

Add-In Manager
 
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

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.

.



All times are GMT +1. The time now is 07:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com