macro

P

Pam Coleman

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,
 
K

Kevin B

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.
 
Top