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,

look in help or the archives for PERSONAL.XLS

--
Don Guillett
SalesAid Software

"Pam Coleman" wrote in message
...
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,

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,