Workbook_open not firing due to compile error in class module (missing library reference)

[Alex2302]

Hi all,
after days of (unsuccessful) research in the web and another forum I try my luck here.
Following problem: I try to add a reference (Outlook library) in the Private Sub Workbook_Open() event (yes, it's in ThisWorkbook) since I need early binding for getting Outlook events later in different places. Once I open my workbook I get a compile error "user-defined type not defined" in my class module here --> Private olApp As New Outlook.Application. I can understand this since the Outlook reference is not yet set and this is what I exactly try to do in the Workbook_Open event. This workbook is going to be used by multiple users. How does Excel work here? Does Excel first try to compile the COMPLETE project BEFORE it executes ANY code (e.g. in the Workbook_Open) event (enableEvents is set to True)?
Once I run the Sub Workbook_open manually, the reference is set without any problems.
Thanks in advance for any help/workaround. I can also accept an answer like: "Alex, you're screwed - there is no solution"

 

[Alex2302]

I found the problem
All buttons and checkboxes in the workbook were Form Controls and different macros were assigned to those controls. I found out that if I remove all macro assignments and reopen the workbook, the compile error disappeared and the reference was set successfully. I replaced all Form Controls by Active X Controls and everything works like a charm. Don't ask me why it didn't work with Form Controls. I'm just glad that it's working now.