I have some VB code that reads about 20 tags from a PLC and communicates through DDE. The code contantly collects data from these tags and lays them out in excel. From there I use Lists to select which data column I want to read.

Everything works fine with my code except that once I start the macro I have no way of stopping it other than hitting ctrl + break. I would rather not have the users stopping the data collection this way but I'm not sure of a solution.

I want to use a stop toggle button , but I don't think I could push it while the macro is running (the working hourglass is up).

Anyone have any solutions?