Workbook_Open event won't fire when another window is active

[trimmjens]

I've been googling this issue a lot without finding a solution.

I have a code in the Workbook_Open event that runs normally when I double click my excel file and wait till it's open.
But if I double click hte file and then activate another window (i.e. my internet browser or a file folder) while waiting for the file to open
the Workbook_Open event won't fire.

Does anyone have an explanation to this?

- EnableEvents is set to True.
- An Autpen Sub is not affected by the same scenario.

 

[Jaafar Tribak]

@trimmjens

Which edition of excel and windows are you using ?

And does that happen only when you open the file from explorer ?

 

[trimmjens]

I'm using Office 365, Win7.

Right now the problem is not there and I can't see what has "solved" it (if it's solved).
This document seems to have another irregular problem too that I struggle to find the cause to.

Very difficult to debug irregular bugs.