Excel 2007

I have workbook with a workbook.open event, which sets up the workbook and
ensures certain pages are visible.

If I open this workbook first every runs fine and the code for activate and
deactivate works well when opening another file.

If I open up another file first, the first time I run the workbook with the
workbook.open event it runs exactly as its suppose to.

If I then close the file with the events and leave the other workbook active
(It has some macros but no workbook.open or activate deactivate events) and
then re-open the workbook with workbook.open event, the event doesn't run.

I have put debug.print code in a certain points and it shows the number of
items run getting less and less

first run shows

workbook.open
workbook.activate

2nd run

workbook.activate


3rd run


(nothing run)


Anyone with any ideas?