Hi royUK
Quote Originally Posted by royUK
I've put Dominic's code in this workbook, it's triggered when the workbook opens
Great minds ... and all that kind of thing
I actually called the module from the Workbook_Open event, and also added something into the Workbook_BeforeClose event cancelling the OnTime macro which can cause an error when the file is closed.

DominicB