Store them in personal.xls
See
http://personal-computer-tutor.com/personalxls.htm
"Tigerxxx" wrote:
How can I write a macro so that it is available for use for all excel
workbooks that I would open in my Excel 2007. Currently I wrote a macro and
it is working only for the workbook I wrote it under.