macro Pam Coleman 27.09.2006 13:28:01 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,

Re: macro "Don Guillett" <dguillett1[ at ]austin.rr.com> 27.09.2006 13:40:33 look in help or the archives for PERSONAL.XLS -- Don Guillett SalesAid Software dguillett1[ at ]austin.rr.com "Pam Coleman" <PamColeman[ at ]discussions.microsoft.com> wrote in message news:648E81F5-D599-44EB-AAB5-F0354E89696C[ at ]microsoft.com... [Quoted Text] > 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,

RE: macro Kevin B 27.09.2006 13:49:02 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: [Quoted Text] > 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,