Excel宏已决定今天停止。 [英] Excel macros have decided to STOP today.
问题描述
Excel宏已经任意决定今天停止。它只是一个短宏,但它决定停止3/4。我点击调试。然后单击继续。它执行下一步,即"ActiveCell.Offset(0,-1).Value = Date"。然后
再次停在下一行。我点击调试。然后单击继续。它处理最终命令,即"退出子"。奇怪!还有其他人在使用Windows 10和MS Office Home and Student 2013时遇到问题吗? (Ted Pustey)2015年12月1日
有史以来最糟糕的Excel错误......
当代码再次停止....按CTRL + BREAK,然后继续...
如果不起作用,请重新启动计算机!
__
下面还有一百万个解决方法:
http://ask.metafilter.com/112071/Code-Execution-has-been-中断
http://stackoverflow.com/questions/2154699/excel-vba-app-stops-spontaneously-with-message-code-execution-has-been-halted
http://www.vbforums.com/showthread.php?777769-code-execution-has-been-interrupted-phantom-breakpoints
http: //optionexplicitvba.com/2013/08/22/the-two-worst-excel-errors-ever /
Excel macros have decided arbitrarily to STOP today. It's just a short macro, but it decides to stop 3/4 of the way through. I click debug. Then click continue. It does the next step, which is "ActiveCell.Offset(0, -1).Value = Date". Then it stops again at the next line. I click debug. Then click continue. It process the final command, which is "Exit Sub". Wierd! Anybody else having trouble with Windows 10 and MS Office Home and Student 2013? (Ted Pustey) December 1, 2015
The Worst Excel Error ever ...
When the code stoppes again.... Press CTRL + BREAK and then continue ...
If not works, restart your computer !
__
There´s another million of workarounds below:
http://ask.metafilter.com/112071/Code-Execution-has-been-interrupted
http://stackoverflow.com/questions/2154699/excel-vba-app-stops-spontaneously-with-message-code-execution-has-been-halted
http://www.vbforums.com/showthread.php?777769-code-execution-has-been-interrupted-phantom-breakpoints
http://optionexplicitvba.com/2013/08/22/the-two-worst-excel-errors-ever/
这篇关于Excel宏已决定今天停止。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!