Strange behavoiur of Workbook_Open() and Worksheet_Activate() events

I have a Workbook_Open() event on a workbook that maximises the application and window (i.e. the workbook).
In the same workbook I have a Worksheet_Activate() event on the various worksheets that sets Zoom to 100% and resets the position of buttons/icons to where they should be.

These events all work perfectly when I open the workbook from my computer or from Sharepoint, however they do not work when opening the workbook from our other UCM system (Oracle).

It isn't a huge issue, really, but it is an annoyance that I could do without if possible. The reasons behind these events are to get around an issue we find occuring frequently where the workbook opens 'off-window' and cannot be seen without using the Arrange Panes option, and to make sure that the worksheets are legible.

Has anyone else come across this issue and/or can suggest potential workarounds?

What is this UCM system? Does it have macro enabled?

Oracle Content Server (Oracle Content Server). Unfortunately I only have user-level access so I cannot answer your other question. However, all of the other events (Worksheet_Change, On_Click, etc) work just fine regardless of where the workbook is opened from.

So you're saying on the Workbook_Open and _Activate events don't fire, but the other events work fine? Certainly strange. Did you try Auto_Open() in the module?

Auto_Open(), which does not seem fully capable anyway (it doesn't recognise maximising the application window when recording), also does not run.

For reference, here is the Workbook_Open() code:

Code:

---

Sub workbook_Open()

'Always maximise the Excel window and workbook
Application.WindowState = xlMaximized
ActiveWindow.ActivateNext
ActiveWindow.WindowState = xlMaximized

End Sub

---

I found that the Worksheet_Activate() code actually is firing - I just didn't notice because the Workbook_Open() was failing.