Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
maxzsim
 
Posts: n/a
Default breaking during a macro run

Hi,

How can i actually stop a macro from running after it has been started ?
is it Ctrl-Break (as in Access , have tried but does not seem to work) ?

appreciate ur advice

tks & rdgs
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rich Mcc
 
Posts: n/a
Default breaking during a macro run

If you want to stop a macro that's currently running, press ESC, and click
End in the Microsoft Visual Basic dialog box.

maybe another option is to put in a msgbox to confirm you want the macro to
run


If you want to prevent automatically running a macro when you start
Microsoft Excel, hold down SHIFT during startup.




"maxzsim" wrote:

Hi,

How can i actually stop a macro from running after it has been started ?
is it Ctrl-Break (as in Access , have tried but does not seem to work) ?

appreciate ur advice

tks & rdgs

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
Search, Copy, Paste Macro in Excel [email protected] Excel Worksheet Functions 0 January 3rd 06 06:51 PM
Closing File Error jcliquidtension Excel Discussion (Misc queries) 4 October 20th 05 12:22 PM
macro with F9 Kenny Excel Discussion (Misc queries) 1 August 3rd 05 02:41 PM
Make Alignment options under format cells available as shortcut dforrest Excel Discussion (Misc queries) 1 July 14th 05 10:58 PM
Playing a macro from another workbook Jim Excel Discussion (Misc queries) 1 February 23rd 05 10:12 PM


All times are GMT +1. The time now is 01:37 AM.

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

About Us

"It's about Microsoft Excel"