Hi Simon,
Same problem as before. I can't find an event which fires before the target is opened and the WorkBook_Open macro has run, so how to trigger your code?