Run a macro witin a macro

[cmb80]

I've heard its possible to "call" a macro from within another but i can't get the code correct.

The macro i need to run is called Sub Macro13() and is in module 20

Thanks

[modytrane]

post your code and identify what isn't working.
modytrane

[colofnature]

It should be as simple as

Module20.Macro13

[jaslake]

Hi cmb80

Try

Call Macro13

John

[just_some_guy]

I have one where I run a whole string of macros one after the other. The first part is of mine is to have a macro to tab to a particular tab, and then another macro for whatever needs to happen on that tab. the "call" part calls up the macro, which is listed right after. So, if I was updating my customer service schedule it would read

    Call Tab_to_Daily_Schedules
    Call Update_CSR_Daily_Schedule
    Call Tab_to_Printable_Schedules_CSR
    Call Update_CSR_Daily_Printable_Schedule
    Call tab_from_Daily_printable_to_Employee_Info_Page

The full macro that this runs in looks like this:

Sub Update_Customer_Service()
'
' Update_Customer_Service Macro
'
    Call Switch_Tab_Master
    Call Update_List_1
    Call Tab_from_CSRGold_to_Gate_List
    Call Update_List_1
    Call tab_from_gate_to_IRR_List
    Call Update_List_1
    Call Tab_from_IRR_to_Flex_List
    Call Update_List_1
    Call Tab_from_Flex_to_VSA_List
    Call Tab_From_VSA_to_VSA_Lead_List
    Call Tab_from_VSA_Lead_to_VSA_Buswash_List
    Call Tab_from_VSA_Buswash_to_Counter_1_List
    Call Update_List_1
    Call Tab_from_Counter_1_to_Counter_2_List
    Call Update_List_1
    Call Tab_from_Counter_2_to_Counter_3_List
    Call Update_List_1
    Call Tab_from_Counter_3_to_Counter_4_List
    Call Update_List_1
    Call Tab_from_Counter_4_to_CSRAdmin_List
    Call Update_List_1
    Call Tab_to_Yellow_Jacket_weekly_Schedule
    Call Update_List_1
    Call Tab_to_Greeter_weekly_Schedule
    Call Update_List_1
    Call Tab_to_DIspatcher_Weekly
    Call Update_List_1
    Call Tab_to_Daily_Schedules
    Call Update_CSR_Daily_Schedule
    Call Tab_to_Printable_Schedules_CSR
    Call Update_CSR_Daily_Printable_Schedule
    Call tab_from_Daily_printable_to_Employee_Info_Page
  
  

'
End Sub

Hope that helps.