How to get a macro to work in all workbooks
 

Hi,

how do I get to run a macro in all the excel workbooks that I open?

one way I know is to store it in PERSONAL.XLS

but I want all the people on the netwok to be able to run the macro, not
just me...

can someone help me?

Thanks
--
Baapi

How to get a macro to work in all workbooks
 

Try an addin

http://support.microsoft.com/default.aspx?kbid=211563
How to create an add-in file in Excel 2000


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Baapi" wrote in message
...
Hi,

how do I get to run a macro in all the excel workbooks that I open?

one way I know is to store it in PERSONAL.XLS

but I want all the people on the netwok to be able to run the macro, not
just me...

can someone help me?

Thanks
--
Baapi

How to get a macro to work in all workbooks
 

You can creat a add-in and install it on every machine
http://www.jkp-ads.com/Articles/DistributeMacro00.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Baapi" wrote in message ...
Hi,

how do I get to run a macro in all the excel workbooks that I open?

one way I know is to store it in PERSONAL.XLS

but I want all the people on the netwok to be able to run the macro, not
just me...

can someone help me?

Thanks
--
Baapi

How to get a macro to work in all workbooks
 

Create an add-in. Put it on the network. Have each person add the add-in to
their instance of Excel.
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Baapi" wrote:

Hi,

how do I get to run a macro in all the excel workbooks that I open?

one way I know is to store it in PERSONAL.XLS

but I want all the people on the netwok to be able to run the macro, not
just me...

can someone help me?

Thanks
--
Baapi

How to get a macro to work in all workbooks
 

thanks bob,

I've also put in another question with the subject being "Geeting data from
a closed workbook"

please answer that as well if you have time...

thansk a lot for your help
--
Baapi

How to get a macro to work in all workbooks
 

thanks Gary,

I've also put in another question with the subject being "Geeting data from
a closed workbook"

please answer that as well if you have time...

thansk a lot for your help
--
Baapi

How to get a macro to work in all workbooks
 

Thanks Ron,

I've also put in another question with the subject being "Geeting data from
a closed workbook"

please answer that as well if you have time...

thansk a lot for your help
--
Baapi

How to get a macro to work in all workbooks
 

Tom already did an excellent job of answering.
Sincerely,
Gary Brown

"Baapi" wrote:

thanks Gary,

I've also put in another question with the subject being "Geeting data from
a closed workbook"

please answer that as well if you have time...

thansk a lot for your help
--
Baapi