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?
Bookmarks