#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 117
Default stopping code

I have a button that runs a series of subs. I sometimes need to quit running
the code in the middle of running it, to do this I just keep hitting excape
until i get a debug to end it. Is their a way that I could have a button
with code that would jump in and end right away? and if possible to tell me
at what sub I have eneded at?

thanks,

Jase
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default stopping code

Hi,

Ctrl+Break and select 'Debug'

Mike

"Jase" wrote:

I have a button that runs a series of subs. I sometimes need to quit running
the code in the middle of running it, to do this I just keep hitting excape
until i get a debug to end it. Is their a way that I could have a button
with code that would jump in and end right away? and if possible to tell me
at what sub I have eneded at?

thanks,

Jase

Reply
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
Stopping a formula Roachy Excel Discussion (Misc queries) 3 July 1st 08 04:31 PM
VBA code stopping in odd places JDub Setting up and Configuration of Excel 2 October 10th 06 09:04 AM
Starting/Stopping Worksheet Event Code Paul987 Excel Discussion (Misc queries) 1 March 20th 06 05:43 PM
Stopping Calculation Kelly Excel Discussion (Misc queries) 2 March 15th 06 11:56 PM
stopping code from looping tjb Excel Worksheet Functions 3 December 7th 05 03:02 AM


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