Steve,

Just put it in the Personal.xls workbook, then add a button and link it to
the macro there. It will then be part of your Excel application.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Steve" wrote in message
...
Hi,

Ive created a macro in order to format a workbook, the
question i have is, is it possible to link to this macro
from the menu bar. I know it is possible to create a
button and link to a macro within a file but the problem i
have is that a new file is creted about twice a month and
so dont want to have to keep copying the macro across from
file to file. Is it possible to say attach the macro to
excel itself so we can run the macro on any book that we
wish once its loaded up? (i.e. not contained within one
particular exdcel work book.)

Cheers

Steve