MrExcel Publishing
Your One Stop for Excel Tips & Solutions

macro within a macro

Posted by chris on November 12, 2001 8:07 AM

can i call a macro from within a macro????

i want to call a macro that works on another workbook from within a macro in my "Main.xls" workbook whick has buttons like a menu.......


Posted by Barrie Davidson on November 12, 2001 8:11 AM

Yes, you can.

Application.Run "Main.xls!Macro_Name"

will run a macro named "Macro_Name" that is in the file named "Main.xls".

Does this help?

BarrieBarrie Davidson