Macro in all workbooks
When I record a macro the option for store macro in, I chose In this
workbook, there is no options for all open workbooks. How do I make this macro be available in all my workbooks? If I create a custom button on the toolbar will this allow the macro to run? Thanks |
To make the macro available to all your workbooks, select 'Personal Macro
Workbook'. As per John Walkenbach's book 'Microsoft Excel 2000 Power Programming with VBA'... If you create some VBA macros that you find [particularly useful, you may want to store these routines on your Personal Macro Workbook. This is a workbook (Personal.xls) that is stored in your XlStart directory. Whenever you record a macro, one of your options is to record it to your Personal Macro Workbook. The Personal.xls file doesn't exist until you record a macro to it'. HTH, Gary Brown "Pam Coleman" wrote: When I record a macro the option for store macro in, I chose In this workbook, there is no options for all open workbooks. How do I make this macro be available in all my workbooks? If I create a custom button on the toolbar will this allow the macro to run? Thanks |
Note thought that this makes it available to all your workbooks, when YOU
open them. If you wnat the code stored in each workbook such that anyone can run them then you need to store the code in each book separately, or have the other person/people store it in their personal.xls -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Gary Brown" wrote in message ... To make the macro available to all your workbooks, select 'Personal Macro Workbook'. As per John Walkenbach's book 'Microsoft Excel 2000 Power Programming with VBA'... If you create some VBA macros that you find [particularly useful, you may want to store these routines on your Personal Macro Workbook. This is a workbook (Personal.xls) that is stored in your XlStart directory. Whenever you record a macro, one of your options is to record it to your Personal Macro Workbook. The Personal.xls file doesn't exist until you record a macro to it'. HTH, Gary Brown "Pam Coleman" wrote: When I record a macro the option for store macro in, I chose In this workbook, there is no options for all open workbooks. How do I make this macro be available in all my workbooks? If I create a custom button on the toolbar will this allow the macro to run? Thanks |
All times are GMT +1. The time now is 08:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com