Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Start a Macro within another Macro
This is a really easy one...
How do I start another macro from within another Macro? Is this the best method? Application.Run "testing.xls!DeleteBoldOtto" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Start a Macro within another Macro
Is this the best method?
Application.Run "testing.xls!DeleteBoldOtto" No, that is the worst method. It is very slow because VBA must find, at run time, the specified procedure. To call one macro from another, just type the macro name. Sub AAA() TheMacro End Sub You can also use the Call statement: Sub AAA() Call TheMacro End Sub but the Call is strictly optional. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Scott Wagner" wrote in message ... This is a really easy one... How do I start another macro from within another Macro? Is this the best method? Application.Run "testing.xls!DeleteBoldOtto" |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Start a Macro within another Macro
If the macro is in the same workbook, just call it
DeleteBoldOtto -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Scott Wagner" wrote in message ... This is a really easy one... How do I start another macro from within another Macro? Is this the best method? Application.Run "testing.xls!DeleteBoldOtto" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sub Macro vrs Function Macro Auto Start | Excel Discussion (Misc queries) | |||
Macro Start | Excel Discussion (Misc queries) | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming | |||
Macro doesn't start up | Excel Programming | |||
Can I start a macro using a # key? | Excel Programming |