How do I run a macro from another file?

[B-52]

We've upgraded to Excel 2007 from Excel 2003. In Excel 2003 I have about 100
macros in a special macro file that I keep open all of the time. This is so
I can run any of those macros for use in another file I'm working in. It
appears Excel 2007 doesn't operate this same way. It sounds like I must have
the macro, I want to use, inside the file I'm working in. I can't call the
macro from another file. Does this mean I must copy all macros I think I
want to run into the file I'm working in? That means every file I work with
will have at least one macro within it. Other people use these files I build
and it will confuse and scare them with the message "this file contains
macros" everytime they open my files.

Any suggestions?

 

[ryguy7272]

I just started using 2007 myself; not happy with it but.........anyway...
Can you put your macro in your Personal.xls folder? Run from there?

HTH,
Ryan---