| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shared Files in Excel | Excel Discussion (Misc queries) | |||
| run excel macros from shared drive | Excel Programming | |||
| Excel icon changes on shared files | Excel Discussion (Misc queries) | |||
| Saving shared Excel files | New Users to Excel | |||
| Can we create/run macros in Shared excel file. How? | Excel Programming | |||
Hybrid Mode
