How do I stop a macro without a Pause button ?

[InTheSummer]

Hi all,

I have a HP Pavilion laptop, which does not have a Pause button. Is there a way to change the Ctrl+Pause shortcut to something else in order to stop a macro?

Thank you!

[Logit]

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 .

[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 Wilkinson be necessary to use the Fn key to get the Pause function.

[InTheSummer]

Thanks guys. Sorry I'm only replying now.

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