This action will reset your project, proceed anyway?

[JenniferMurphy]

I am getting this message after I made a couple of edits to a macro and then tried to rerun it. Behind the message, all of the code in that module is selected. If I click Ok, it is all deleted. If I click Cancel, the code is still selected. If click anywhere, the selection goes away and I see that the macro declaration is highlighted in yellow indicating break mode. If I click Run and Reset, break mode is cleared, but if I rerun the macro, it all happens again.

Any clues to what I did this time to cause VBA to torture me this way?

 

[JenniferMurphy]

The behaviour you described was exactly what would happen if the focus didn't go to the immediate window following the ^g part of the sendkeys code. I would never use sendkeys unless there is literally no option.

The websites where I found the Sendkeys code had some warnings that it was flakey. I there any other way to clear the Immediate window?

Thanks