LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
DPK DPK is offline
external usenet poster
 
Posts: 1
Default stopping macro

I have a procedure macro that calls a dialog box. After
parameters are input, the user clicks an "Ok" button and
the macro runs. At times the procedure can take a very
long time to run. Is there a way to allow the user to
break the macro and not wait until it finishes? I have
only been able to use [CTRL][ALT][DEL] and end Excel, but
obviously that is not a very good solution. I have tried
to use the [ESC] key, but it just ignores the key press.
Maybe a status dialog box with a cancel button? Anyone
used anything they feel works well?

Thanks in advance,
Dave

 
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
Protect macro from stopping saman110 via OfficeKB.com Excel Discussion (Misc queries) 1 August 16th 07 08:22 PM
Stopping Excel macro pattern recgonition mal1920 New Users to Excel 2 November 17th 05 05:10 AM
Stopping an animation macro Ray Kanner[_2_] Excel Programming 3 November 23rd 03 11:40 PM
My Macro keeps stopping?? Sh0t2bts Excel Programming 5 October 28th 03 03:08 PM
Stopping a macro without using Ctrl Break Julian[_2_] Excel Programming 1 October 27th 03 02:39 AM


All times are GMT +1. The time now is 02:28 PM.

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"