Hi
either rename the macro to Auto_Open()
or put the code in the workbook event Workbook_open()

--
Regards
Frank Kabel
Frankfurt, Germany


JIM.H. wrote:
Hi,
I have a excel file that keeps the macro recorded. Now
What I want to do each time I open another excel file,
that macro should be run automatically, how can I do this?
Thanks,
Jim.