Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro run order
hi,
is there a way of setting some order in macros? for instance, i don't want macro2 and 3 to run if macro1 hasn't. thank's. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro run order
Rui,
One way.... Set a Public variable within Macro1. Public ItRan as Boolean Sub Macro1() ItRan = True ' your code End Sub Sub Macro2() If ItRan = False Then Exit Sub ' your code End Sub John Rui wrote: hi, is there a way of setting some order in macros? for instance, i don't want macro2 and 3 to run if macro1 hasn't. thank's. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
URGENT: Please help with tab-order macro | Excel Discussion (Misc queries) | |||
Macro with custom sort order | Excel Worksheet Functions | |||
Reverse column order with a macro | Excel Discussion (Misc queries) | |||
Newbie Order-Entry Macro | Excel Discussion (Misc queries) | |||
Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions |