How do I stop a macro without a Pause button ?

Each of these resources speaks to the practice of ONKEY code. In essence, via VBA assign a macro to perform
an action when certain key (or keys) are pressed.

These sites should give you sufficient info to create your own ONKEY ...



https://msdn.microsoft.com/en-us/lib.../ff197461.aspx

http://www.rondebruin.nl/win/s4/win012.htm

https://www.youtube.com/watch?v=MbHYJOvdv8s

http://superuser.com/questions/61414...y-in-excel-vba


Also: depending on your existing macro code ... it may be possible to add additional coding that would pause it .

Thanks guys. Sorry I'm only replying now.

Originally Posted by cytop

There should be a Pause key. You'll probably find it printed faintly on the right hand shift key.

If so Ctrl + (maybe an)Alt + Fn + Pause/RH Shift might work but the key mappings are not consistent. In any cause it should be necessary to use the Fn key to get the Pause function.

Oh my god, you are saving my life here! Fn+Pause had never worked, but Ctrl+Fn+Pause does! I wish I had known this much earlier! No more crashing Word / step-by-step / too-short loops for me! :D

Thanks a lot.<3