It depends what your macro does and where it is located. I've achieved
this by putting the macro in a "master" file and when I run the macro
it opens file_1, does what it needs to do, saves and closes file_1,
opens file_2, does something else with that then saves and closes it,
and so on. The master file remains unchanged at the end of the
exercise.

Hope this helps.

Pete

ahsya wrote:
I have about 5 excel files that I want to run one macro on all five. As soon
as I run the macro on one excel file, it won't work on the next. I have to
close the macro, open it again, then run the macro on the excel spreadsheet,
etc. Is there a way around this?