combining macros

[Guest]

If you write several macros and then write a macro that runs all the macros you have written it will then have your excel file name as part of it. If you save this file under a different name the macro that runs all macros does not change the file name, thats part of the macro, to the new name. Is there a setting that will enable this to change or something else that can be done to have it automatically change with the file name change?

Thanks

 

[jeff]

Hi,

There is no setting you mention. But I'm not sure why
this is a problem. All the macros are stored in your
excel file - you'll see the filename preceed each macro
if you have multiple workbooks open (naturally, each
workbook may have its own set of macros). However when
you save the original workbook with the regular macros
and the one that runs them, they all get saved with the
file - no need to worry about the names - they all go
with the file.

What am I not understanding about your concerns??

jeff

-----Original Message-----
If you write several macros and then write a macro that

runs all the macros you have written it will then have
your excel file name as part of it. If you save this file
under a different name the macro that runs all macros
does not change the file name, thats part of the macro,
to the new name. Is there a setting that will enable this
to change or something else that can be done to have it
automatically change with the file name change?

 

[jgett]

Matt,
You can save macros in your personal macro workbook. See this link
Macros saved there are accessable from any workbook.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;28811