LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default Stop Multiple Macros

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Programmatically open XLT for edit and stop macros XP Excel Programming 4 August 2nd 07 03:07 PM
linking of macros with other workbooks. need to stop it! KyWilde Excel Discussion (Misc queries) 1 March 10th 05 07:13 PM
Stop 'Disable Macros' BowMag Excel Programming 4 November 9th 04 01:37 AM
How to stop macros in 2nd workbook? Joe 90[_2_] Excel Programming 0 December 2nd 03 11:27 PM
How to stop macros in 2nd workbook? Joe 90[_2_] Excel Programming 1 December 2nd 03 10:37 PM


All times are GMT +1. The time now is 06:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"