VBA to stop any actively running procedures

[johnny51981]

I'm trying to make my reports a bit more not-me user friendly, so when I'm out the person covering me doesn't have to get too technical. (I'm just saying "dumb down" in a nicer way).

Anyhow.

The last thing that I am not able to get built in is basically an emergency override. The reports all currently have VBA written in to refresh Power Queries and then export, save, do a twirl, and say goodbye. There are cases where I need to stop everything mid refresh for one reason or another, and know how to cancel the queries no problem, but there are some resetting steps that also need to be done.

Is there some code where I can cancel the Refresh All? If so, what would that look like?

 

[Micron]

Don't know if your idea is possible or not. If you don't receive something that does that consider having your code make a backup copy before running anything. If all goes well, have code delete the backup. If not, roll back using the backup.