Install excel xp (2002) add-in instructions don't work

[Soldier52]

I have searched multiple excel forums and professional excel user sites for
instruction to install an add-in. None of the instructions work. The most
recent from a pro said click tools>insert then choose user defined, (UD), in
the paste function option. I use excel xp, aka 2002. When I click
tools>insert, neither user defined or paste function appears. The only thing
displayed is a list of excel built in functions to choose from. Also read
other methods to install a UD function, none of which work. I saved a macro
as an add-in (xla file) and would like to install it. Example: I downloaded a
function in a zip file. When I unzipped the file it appeard on the add-in
list automatically. My add-in doesn't appear in the list but the original
macro does. My goal is to assign the add-in to a button. Can this be done?

 

[Gord Dibben]

An add-in is a file/workbook. It is not a macro.

Macros and UDF's live in a module within the add-in.

To install the add-in, store it in your Office\Library folder.

Open Excel and go to Tools>Add-ins and select your add-in from the list.

Any UDF's in that add-in will be available in the User Defined category of
the Function Wizard (Fx)

Any macros in that add-in will not appear in the Tools>Macro>Macros dialog
but can be accesed by name for you to assign to the button.


Gord Dibben MS Excel MVP

 

[Soldier52]

An add-in is a file/workbook. It is not a macro.

Macros and UDF's live in a module within the add-in.

To install the add-in, store it in your Office\Library folder.

Open Excel and go to Tools>Add-ins and select your add-in from the list.

Any UDF's in that add-in will be available in the User Defined category of
the Function Wizard (Fx)

Any macros in that add-in will not appear in the Tools>Macro>Macros dialog
but can be accesed by name for you to assign to the button.


Gord Dibben MS Excel MVP



Thanks for responding. Excel XP looks for add-ins in the documents and settings add in folder. When I move the file I get an error message that it can't be found in the docs and settings add in folder. I've switched the file back and forth numerous times. Perhaps what I would like to accomplish can't be done. All the experts I've asked ignore my comment that a UD option does not appear in my function wizard, that is, no UD category is displayed in the functions wizard. Perhaps my copy of excel is defective.

 

[Gord Dibben]

Excel by default looks in the Office\Library for add-ins.

BUT................

You can go to Tools>Add-ins>Browse and go to any folder to select an add-in
to load from that folder.


Gord