![]() ![]() The prudent use of calling DoEvents in lengthy calculation loops will improve computer usage in general, as well as improving yours chances of breaking a running macro. Also, I believe we cannot break a macro if it is waiting for input or the network, for example. On my single-core single-CPU computer, if the macro is in a tight CPU-bound loop, often I cannot break it or it takes a v-e-r-y long time. However, the success of breaking a macro depends on what it is doing at the time, and perhaps on how many CPUs (virtual and real) you have. I can press ctrl+Pause to simply break a running macro. ![]() On my (ancient) Dell laptop, I press ctrl+alt+Pause to have the option to End or Debug (break) a running macro. So I am guessing that the key combinationsĪs you discovered, the actual keystroke to use depends on the computer manufacturer, not the version of Excel or Windows. I do see a SysRq and Pause button and I have used them in combination with CTRL but nothing happens. On my laptop keyboard I do not see an explicit BREAK button. Step 3: In the tab of the Open dialog box, click the broken excel file. Step 2: Select the location and folder which contains the broken excel file. ![]() I am using Excel 2010 on Windows 7 platform. Step 1: Select File and click on the option of Open. How could I interrupt a macro that is being executed? In good old days we had the CTRL-BRK combination, but now I am not sure anymore. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |