Linking macros

  • Thread starter Thread starter out of my depth
  • Start date Start date
O

out of my depth

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
 
Within the one macro you call, use

Application.Run "WorkbookName.xls'!MacroName"

And repeat as needed for each macro you want to run.
 
You can just call other routines:

Option Explicit
Sub RunThemAll()
call runthefirst
call runthesecond
call runthethird
End sub
 
Great, very easy and worked a treat. Cheers!

Dave Peterson said:
You can just call other routines:

Option Explicit
Sub RunThemAll()
call runthefirst
call runthesecond
call runthethird
End sub
Click to expand...
 
Back
Top