James

You seem to be using OnTime quite a lot in that code.

The only thing you don't do is disable it when you close the workbook.

Doing that should stop the workbook re-opening.