Workbook_Open event won't fire when another window is active

trimmjens

New Member
Joined
Oct 26, 2012
Messages
44
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 Auto_Open Sub is not affected by the same scenario.
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
@trimmjens

Which edition of excel and windows are you using ?

And does that happen only when you open the file from explorer ?
 
Last edited:
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,224,820
Messages
6,181,159
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top