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

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

Thanks Steve this helped me out too. But now when I try to edit this macro
it tells me that I first have to unhide the workbook to edit it. Now the
problem is I do not remember which workbook I used originally to create
this global macro.

Please could you help?
Thanks
Ronnie

"Bob Phillips" wrote in message
...
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

Just go into WindowUnhide and try each hidden workbook one by one.

--

HTH

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

"Rohinton Sarkari" wrote in message
...
Thanks Steve this helped me out too. But now when I try to edit this
macro
it tells me that I first have to unhide the workbook to edit it. Now the
problem is I do not remember which workbook I used originally to create
this global macro.

Please could you help?
Thanks
Ronnie

"Bob Phillips" wrote in message
...
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