when I create a macro I save it in excel as macroxxx.xls when I create
the new file I have both files open, the macroxxx.xls and the
newfile.xls then I go tools, macro, macros, run on the new file.
Is there really a need to have both files open in order to run the
macro?
is there a place I can save the macro and then when I open the new file
just retrieve the macro from within that file?

Thanks in advance to any one that answers.


--
chin_un_len
------------------------------------------------------------------------
chin_un_len's Profile: http://www.excelforum.com/member.php...o&userid=30914
View this thread: http://www.excelforum.com/showthread...hreadid=511252