This isn't typical behavior, so it is hard to say how to fix it. What do you
think is preventing the macro from running a second time? Are you getting an
error message - what are the symptoms that indicate it is not allowed to run
again?

--
Regards,
Tom Ogilvy


"ahsya" wrote:

I have different files each quarter that I export into excel, then run the
same macro on all of them. The macro does not allow me to run it in the same
instance. After running it once, I have to close the macro, open it back up
then run it for the second spreadsheet, etc. Is there any way around this
problem, so I can run the control-y macro consistantly without having to
close it out to run more than one instance?