View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lazzaroni Lazzaroni is offline
external usenet poster
 
Posts: 55
Default Escape Key Interrupts Code Execution in Add-In

I have an .xla add-in for Excel that displays the "Code execution has been
interrupted" dialogue box whenever I press the Escape Key.

ThisWorkbook.IsAddin is set to True and the add-in is password protected for
viewing, so this should not be happening.

There are four buttons in the dialogue: Continue, End, Debug, and Help. The
Debug button is disabled unless I have entered the password and have the
add-in opened in Visual Basic, so the user can't see the code, but the
dialogues should not be displaying at all.

I have created new .xla add-ins from scratch, loaded them, and pressed
escape while a process from the add-in is running and I do not get the "Code
execution has been interrupted" dialogue box.

Can anyone suggest a reason why this is happening and how to make it work
normally again?

Thank you.