Excel宏已决定今天停止。 [英] Excel macros have decided to STOP today.

查看:193
本文介绍了Excel宏已决定今天停止。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

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屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆