How to cancel running excel macro? Use a shortcut to stop it?

How can I cancel running excel macro ? I am trying to pause it or stop it by clicking on the buttons, but it doesn't work. Is there a shortcut to stop running macro ?

Yes, excel window will become useless while running a macro. So you can't really click on the button to pause or stop your macro.

Depending on your excel version, you can try the following actions to stop running your macro:

• ESC
• Ctrl + Pause Break
• Ctrl + Alt + Pause Break

Alternatively, if none of the options above work, you can try to close the whole excel in the Task Manager. To go to the Task Manager, you have to press Ctrl + Alt + Del. Please mind if you close excel via Task Manager, you may lost all your unsaved data.