Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get a macro to work in different workbooks ? | Excel Programming | |||
How to get a macro to work in different workbooks ? | Excel Programming | |||
How to get a macro to work in different workbooks ? | Excel Programming | |||
Edit Macro to work for other Workbooks | Excel Programming | |||
Macro, Persoanl Work book and CSV workbooks | Excel Programming |