M
Mike
I was wondering if there was an easy way to transfer a
bunch of macros to 5 other computers? Any help would be
great, thanks!
bunch of macros to 5 other computers? Any help would be
great, thanks!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Ron de Bruin
Hi Mike
Save a file with the macro's as a Add-in and distribute that one
http://support.microsoft.com/default.aspx?scid=kb;en-us;156942&Product=xlw
How to Create an Add-in File in Microsoft Excel 97
Or import the module's (or copy the macro's) in the personal.xls file on each machine
Save a file with the macro's as a Add-in and distribute that one
http://support.microsoft.com/default.aspx?scid=kb;en-us;156942&Product=xlw
How to Create an Add-in File in Microsoft Excel 97
Or import the module's (or copy the macro's) in the personal.xls file on each machine
F
Frank Kabel
Hi
one way would be to create an addin and install this add-in on all
other computers
one way would be to create an addin and install this add-in on all
other computers
D
Dave Peterson
Or just put all your subroutines in another workbook and share that workbook.
Tell the end users to open that workbook and hit alt-f8 (tools|macro|macros) to
run your macros.
(I would think you'd want to make sure your code was written to work against the
activesheet???).
If you want to share lots more macros, John Walkenbach has a nice procedure at:
http://j-walk.com/ss/excel/tips/tip53.htm
It's called menumaker. It's really simple to use and looks very
nice/professional.
Tell the end users to open that workbook and hit alt-f8 (tools|macro|macros) to
run your macros.
(I would think you'd want to make sure your code was written to work against the
activesheet???).
If you want to share lots more macros, John Walkenbach has a nice procedure at:
http://j-walk.com/ss/excel/tips/tip53.htm
It's called menumaker. It's really simple to use and looks very
nice/professional.