Add the macro to your PERSONAL.XLS workbook. When you record a macro you
can either save the macro to the current workbook, a new workbook or the
personal workbook. Select the latter and it will automatically open this
file as a hidden file each time you start excel.

--
Kevin Backmann


"Pam Coleman" wrote:

How do you keep a macro in all your workbooks, I notice when I create a macro
in one workbook and then create a new workbook, my macro is gone. Thanks,