hi
save your macro to a workbook named Personal.xls then save that file to the
xl start folder. on my pc the xl start folder is at....
c:\program files\microsoft office\Office10\xlstart
the personal file should be hidden and will open on starting excel and all
macros in the personal workbook will be available. in my personal i have
about 9 macros, 6 of which i run from a custom menu.

hope this helps
regards
FSt1

"Tim" wrote:

If you create macros in on file/workbook...is there a way to store them
somewhere so they can be used in any other similar workbook that might be
created ? Can you store them in some file and then import/export them to
other files ?

Thanks, Tim