macro
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, |
macro
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, |
macro
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, |
All times are GMT +1. The time now is 05:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com