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

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

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

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