ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   breaking during a macro run (https://www.excelbanter.com/excel-discussion-misc-queries/76098-breaking-during-macro-run.html)

maxzsim

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

Rich Mcc

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



All times are GMT +1. The time now is 07:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com