Code Execution Interrupted

[Guest]

We have a user who has been experiencing issues when running macros
(primarily out of Microsoft Excel) where when a form/dialogue is usally about
to be presented they recieve a

Microsoft Visual Basic
Code Execution has been interrupted

Options includes the Continue, End and Help button. (the Debug is greyed out).

This seems to happen randomnly with different macros (and does not
necessarily appear on other users PCs who run the same macro). I've logged on
myself on the PC and been unable to replicate the issue.

We've removed pdfmaker templates/add-ins. Though there is still a TM1 and
Vision add-in as well as the Analysis Pack add-in.

Does anyone know what causes this? Why the debug is greyed out? and how we
can resolve this?

Any ideas would be appreciated.

 

[George Nicholson]

I've seen Debug greyed out when the code causing the problem was in a
protected project. (But if the Project is opened in the VBE with a password
before the code was run, debug would be available.) This behaviour makes
perfect sense: when code is protected, you can't debug it.

I don't know if there are other conditions under which Debug is unavailable.
If not, I'd guess that it points at the remaining add-ins as the problem
source. I'd consider the Analysis pack as the least likely suspect under the
conditions you specify (an imminent dialog form). I don't know enough about
the other 2 to venture a guess.

HTH,