Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I currently have multiple macros that run in a hierarchal manner. The first
one calls the second macro, which calls the third macro, etc. There are certain If statements in each macro that should end that macro and all macros running before it. Using Exit Sub with the If statement only ends the macro that the If statement is located in. The previous macros then pick up where they left off. I need a statement that will communicate to all running macros that if "this" is true in this macro then end all running macros. I investigated VBA help and came up with using End in the place of Exit Sub, but it apparently closes all opened files and I don't want that to happen. Any advice for a newbie? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Programmatically open XLT for edit and stop macros | Excel Programming | |||
linking of macros with other workbooks. need to stop it! | Excel Discussion (Misc queries) | |||
Stop 'Disable Macros' | Excel Programming | |||
How to stop macros in 2nd workbook? | Excel Programming | |||
How to stop macros in 2nd workbook? | Excel Programming |