Excel macros - shared between different xls files?

C

cleanwire

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
 
G

Gleam

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top