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