Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking macros
This is going to sound v.basic but is there a simple way to run a few macros
on the same shortcut key? If not is there a simple way to link seperate bits of code. Thanks very much! T |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking macros
Within the one macro you call, use
Application.Run "WorkbookName.xls'!MacroName" And repeat as needed for each macro you want to run. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "out of my depth" wrote: This is going to sound v.basic but is there a simple way to run a few macros on the same shortcut key? If not is there a simple way to link seperate bits of code. Thanks very much! T |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking macros
You can just call other routines:
Option Explicit Sub RunThemAll() call runthefirst call runthesecond call runthethird End sub out of my depth wrote: This is going to sound v.basic but is there a simple way to run a few macros on the same shortcut key? If not is there a simple way to link seperate bits of code. Thanks very much! T -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking macros
Great, very easy and worked a treat. Cheers!
"Dave Peterson" wrote: You can just call other routines: Option Explicit Sub RunThemAll() call runthefirst call runthesecond call runthethird End sub out of my depth wrote: This is going to sound v.basic but is there a simple way to run a few macros on the same shortcut key? If not is there a simple way to link seperate bits of code. Thanks very much! T -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Macros | Excel Discussion (Misc queries) | |||
linking individual macros on the same sheet | Excel Discussion (Misc queries) | |||
linking of macros with other workbooks. need to stop it! | Excel Discussion (Misc queries) | |||
Linking and/or macros | Excel Worksheet Functions | |||
Macros and Linking | Excel Worksheet Functions |