M Mike Aug 3, 2004 #1 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!
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!
R Ron de Bruin Aug 3, 2004 #2 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
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
F Frank Kabel Aug 3, 2004 #3 Hi one way would be to create an addin and install this add-in on all other computers
D Dave Peterson Aug 4, 2004 #4 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.
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.
