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: 13
Default Stop Command Question

I have a macro (let's say in macro1 in workbook1) I was checking out, so I put a stop command in the code so that execution would pause and I could see what data the macro had transferred to the worksheet and see if everything was correct. The stop command works fine, just as expected. However, if I open workbook1 from a macro2 in workbook2 and then run macro1 using Application.Run, the stop command doesn't halt execution, macro1 just runs to completion. Is that always the case that if you call a macro from a macro in a different workbook, stop commands don't function?..TIA, ron
 
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
How to set a tab stop for a command button Jeff Ciaccio Excel Programming 2 June 14th 08 04:29 PM
stop command does not trigger Peter[_21_] Excel Programming 2 January 28th 08 03:19 AM
Stop Command Button being copied to new Workbook Ledge Excel Programming 1 March 31st 06 04:49 PM
ClearContents command causes routine to stop Peter Ekstrom Excel Programming 1 April 11th 05 08:55 PM
IF Command to Stop Macro ianripping[_23_] Excel Programming 4 January 16th 04 04:35 PM


All times are GMT +1. The time now is 01:34 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"