How do I load an Add-ins

[Guest]

I have created macro that I would like to share with other excel users on the
network. I was told I could save the macro to a workbook and save it as an
“Add-ins†file on the network for others to load.

I have done this but I can not figure out how to “Load Itâ€. I can find the
workbook file on the network and I can select it to be copied into my
“Add-ins†file but I do not know how run the macro in the add-ins workbook in
the workbook I am currently working in. Does anyone know how to do this?

Thanks,

Erin

 

[Ron Rosenfeld]

I have created macro that I would like to share with other excel users on the
network. I was told I could save the macro to a workbook and save it as an
“Add-ins” file on the network for others to load.

I have done this but I can not figure out how to “Load It”. I can find the
workbook file on the network and I can select it to be copied into my
“Add-ins” file but I do not know how run the macro in the add-ins workbook in
the workbook I am currently working in. Does anyone know how to do this?

Thanks,

Erin

From the main menu select

Tools/Addins
Browse
Navigate to the xla file and select it
Then ensure that it is selected.

--ron

 

[Guest]

Thanks Ron,

I have alrready done this but how do I get the macro to run?

Erin

 

[Gord Dibben]

Erin

See response to same question earlier.


Gord Dibben MS Excel MVP

 

[Ron Rosenfeld]

Thanks Ron,

I have alrready done this but how do I get the macro to run?

Erin

You will need to supply more information.

It will ordinarily run the same as it would on your original. You type the
name into the macro name slot of the macro dialog box, and select Run.
--ron