Linking macros

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
 
L

Luke M

Within the one macro you call, use

Application.Run "WorkbookName.xls'!MacroName"

And repeat as needed for each macro you want to run.
 
D

Dave Peterson

You can just call other routines:

Option Explicit
Sub RunThemAll()
call runthefirst
call runthesecond
call runthethird
End sub
 
O

out of my depth

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
 

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