Workbook Opens in Tray Instead of MAXIMIZED

[dgarber]

Hi Everyone,

I have 3 Excel Macro files that open in the tray and not maximized as expected? All other Excel files open maximized as they should.
Does anyone have an idea with whats going on with that?

Thanks,
Dean

[Fluff13]

Do you have a workbook_open event, or Auto_Open code in those workbooks?

[dgarber]

Hi Fluff,
Yes I do but the weird thing is its been functioning fine until yesterday when it started this nonsense on those 3 workbooks!

Please Login or Register  to view this content.

[Fluff13]

I can't see anything there that would cause this, but then I don't understand some of it.
Not sure if this would help, but you could add the word stop like

Please Login or Register  to view this content.

Save & close the workbook, then when you re-open it the code will stop running at the Stop line & you can then use F8 to step through the code, to try & see where its going wrong.

[dgarber]

In a nutshell its opening an HTML file, select all, copy and then paste to a sheet in the workbook but I'll give your suggestion a whirl.

[dgarber]

Hey Fluff,
Tried your suggestion but I am not getting any errors when stepping through the code so I'm not sure what is going on?
It appears that Office 365 performed an update on 11/29 when this started happening so I wonder......
Thanks,
Dean

[Fluff13]

Sorry I couldn't be of more help.

[dgarber]

Hi Fluff,
Turns out after some experimenting that I was mistaken. The Excel file is opening but hiding behind other applications that are open. This seems to be happening
when the Excel file is opened from file manager but as indicated just started happening a few days ago? Still haven't figured out a solution.

Thanks,
Dean