How to Stop a Macro Safely?

I have a for loop and while the macro is running I see an hour glass icon represents loading and does not let me click on any buttons, however I am trying to safely get out of the loop without hitting Ctr + Pause. Does anyone have any experience with this. On top of my for loop I have an if statement.

Please Login or Register  to view this content.

And if the stop button is pressed it will make stopkey = "1" however I am unable to press it during when the macro is running.

Any help, thanks.

Hi

Have a look at doevents.

Say you have something like

Please Login or Register  to view this content.

Make sure there is nothing in A1, run the code and it will keep incrementing B1. While it is running, you will be able to go to A1, and enter 1. The macro will stop.

HTH

rylo