That is the purpose of Excel's Personal.xls macro workbook.

Record and/or create macros to Personal Macro Workbook and these macros will be
available for all open workbooks.

Personal.xls is stored in your XLSTART folder and opens hidden when Excel is
started up.

For more on Personal.xls see here.............

http://snipurl.com/1kugy


Gord Dibben MS Excel MVP

On Tue, 2 Oct 2007 06:38:01 -0700, Chi wrote:

Hi

I have a macro that runs well on the A workbook. I would like to use that
macro for different workbook. Is it possible to do that? Please help

Thanks
Chi