Generic Macro

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

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)
 
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
 
Just go into Window>Unhide 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)
 
Back
Top