Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Help with Macro (copying data from multiple workbooks) | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) | |||
Workbooks...I'll try this again... | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) |