Excel 2013 macros "Not Responding"

[softik]

Why Does Excel 2013 macros will sometimes notice "Not Responding" and shortly after the program goes forward.

[cytop]

Probably because it's busy running code, especially if you're running in a loop and updating a worksheet that causes cascading events.

Impossible to say exactly without seeing your code, but you could try adding a

DoEvents

statement in a strategic point on the code; however, this will slow down the processing...

[softik]

Using the following code, the message "Not Responding" did not come (it code neutralizes the "Not Responding" message):

CreateObject("WScript.Shell").Popup "Found the answer to the following ...", 1, " Message ... "

Perhaps the VBA language finds that the program leads to a cycle in my code?

[softik]

Excel 2007 environment, this message (Not Responding) does not appear, even though the macro code is the same.