When open an old xls, an new macro is in a new module.
 

I assume you mean record a macro. I don't think you can change that
behavior, but you can always copy the recored code to module1 and delete the
new module.

--
Regards,
Tom Ogilvy

"Peter" wrote in message
...
Whenever I open an old xls file, then I assing an new macro, the Excel
automatically assign the code in a new module. Is there is any way you can
configure it to assign the new macro in Module1? Please advise.
Peter