Excel macros - shared between different xls files?
 

Can macros be "shared" or must they belong to a specific file? Put
another way... can macros contained in one spreadsheet be run against
other spreadsheets which don't have that macro? Example...
a.xls has a macro
b.xls is in the same format as a.xls but does not have the macro.
When I open b.xls, can I run the macro in a.xls?
Thanks Marty

Excel macros - shared between different xls files?
 

If in file a you use tools/macros/macros/options and set the macro to run
when you type control m, then if you have files a and b open, and a cell in
file b selected, when you type control m the macro should run and do its
stuff on file b.

" wrote:

Can macros be "shared" or must they belong to a specific file? Put
another way... can macros contained in one spreadsheet be run against
other spreadsheets which don't have that macro? Example...
a.xls has a macro
b.xls is in the same format as a.xls but does not have the macro.
When I open b.xls, can I run the macro in a.xls?
Thanks Marty