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

On Fri, 10 Nov 2006 11:51:02 -0800, Erin
wrote:

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

Thanks Ron,

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

Erin

"Ron Rosenfeld" wrote:

On Fri, 10 Nov 2006 11:51:02 -0800, Erin
wrote:

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

Erin

See response to same question earlier.


Gord Dibben MS Excel MVP

On Fri, 10 Nov 2006 13:22:01 -0800, Erin wrote:

Thanks Ron,

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

Erin

"Ron Rosenfeld" wrote:

On Fri, 10 Nov 2006 11:51:02 -0800, Erin
wrote:

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

On Fri, 10 Nov 2006 13:22:01 -0800, Erin
wrote:

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