Code to allow stopping of Workbook_Open() by User

[egiannaros]

I have a Workbook_Open() Macro that works perfectly right now. The macro is set up as a workbook open (workbook open, forces the macro to run when the file is opened) so I can run the process overnight using Windows Task Scheduler.

All I need to do now is to add some code that will generate a pop up window with a button that the user can click in order to stop the macro from executing if he/she chooses to do so. I would like the window to be visible for 5 seconds.

The point of this is to allow the user to stop the macro from running (besides using Ctrl+Break).

Any help would be greatly appreciated. Thanks.