Macro in all workbooks

P

Pam Coleman

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
 
G

Gary Brown

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
 
K

Ken Wright

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 said:
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 said:
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
Click to expand...
Click to expand...
 
Top