Copy a macro between workbooks

[Tio]

I'm running office 2000. I'm trying to copy a set of
macros from one workbook and make them available to all my
workbooks. How do I avoid having to open the workbook
containing the macros everytime I want to use them? How do
I make these macros global, all the time? PLEASE HELP!!!!

 

[Frank Kabel]

Hi
put the UDF in your Personal.xls file. Have a look at
http://www.mvps.org/dmcritchie/excel/getstarted.htm
for instructions