Workbook Opens on Missing Monitor

Learn Excel from MrExcel Podcast, Episode 2094: Workbook Opens But Is Not Visible 

Hey, today's question is sent in by me.  This happened a couple of days ago, I opened a new workbook: File, Open and the workbook opened.  It appeared to open fine except I couldn't see it.  And it wasn't this weird problem where I have a blank workbook down in the Status Bar.  Down in the Status bar, the Task bar is actually showing me both workbooks are down there.  I just simply couldn't see it.  And if I would go to View and Switch Windows, right - there it is but it was never opening up. 

And I finally realized that this workbook had not been opened for a couple of years and the last time that I opened this workbook, I owned two monitors.  I had dual monitors on this computer and that somehow, that other workbook was sitting over on the second monitor that's no longer there.  Alright, and I had used some VBA to get the .Left and .Top of the window back where I could see it.  But here's a great trick, if you have the Flying Windows key.  So on your keyboard between the left Ctrl and the left Alt, you might have the Windows key.  If you hold down the Windows key and press the Left Arrow, it will bring the active window back into view; or Windows Right Arrow will move it to the right half of the screen.  So either Windows Left or Windows Right will bring it back.  So, just a quick little tip today.  I guess it’s really now an Excel trick, it’ll work with any apps at all. 

Well, that was so short.  Don't even need to wrap it up, just a Windows key and either Left Arrow or Right Arrow to bring a missing app back into view.