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