+ Reply to Thread
Results 1 to 2 of 2

Excel window keeps going full screen

  1. #1
    Registered User
    Join Date
    08-21-2020
    Location
    Spain
    MS-Off Ver
    Microsoft Office 365 ProPlus (version 1908)
    Posts
    1

    Excel window keeps going full screen

    Hello,

    A couple of days ago I opened an Excel file that had a macro to set hide pretty much everything (ribbon, workbook tabs, formula bar) upon opening. I feel restricted when working with this kind of files so I Alt+F11'd and run the macro to show again all those features. However, whenever I moved to another sheet the macro activated again and hid everything. I then commented the whole macro so I would not happen again and that fixed it for that one sesion.

    Yesterday I created a new Excel file (from scratch, no macros) and was working as expected until I tabbed out: when I tabbed back in, everything was hidden (Picture 1). No other workbook was open. I used to fix it by running Application.DisplayFullScreen = False, but today I found out that double clicking on the up-most bar also works (Picture 2)... until I tab out and everything disappears (again Picture 1). This is specially annoying when working with split window as clicking away and back on the workbook triggers this event. For some reason it doesn't happen on all workbooks, but on those in which it does it happens every single time.

    It doesn't happen on any other MS Office software and I even restarted the PC but still.
    I don't believe this is a bug, rather a setting that must have been altered when running the first macro that started the whole thing.

    Does this event sound familiar to anyone? Any idea on how to "fix" it?
    I would really appreaciate the help, thanks in advance for your time!

    Picture 1: everything hidden but the top bar and workbook tabs.
    Anotación 2020-08-21 155332.png

    Picture 2: clicking on the top bar restores the view until next tab-out
    Anotación 2020-08-21 153348.png

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Excel window keeps going full screen

    .
    From my experience ...

    Usually that type of macro is initiated when the workbook is opened. The macro code is either located in the ThisWorkbook module (Workbook_Open) or
    there is a "call" to the macro in the same location ... and the macro itself is located elsewhere.

    Check the ThisWorkbook module (Workbook_BeforeClose) and make certain there is either a macro or a call to a macro that completely returns the
    workbook view to normal when closing.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Open Workbook in "Full Screen" mode but with sized "Window" View
    By HGL in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2016, 05:54 AM
  2. How do I make Excel stay in Full-screen ?
    By white-k in forum Excel General
    Replies: 2
    Last Post: 04-10-2015, 12:30 PM
  3. Double Click Excel Window Title Bar Duirng Full Screen Mode
    By Badrul Hisham in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2015, 11:50 AM
  4. Full screen after window is minimized
    By lsteinbach in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2013, 06:01 PM
  5. Full Screen in Smaller Window
    By Steve_Courts in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-01-2011, 07:24 AM
  6. Excel workbook won't maximize for Full screen
    By anoble1 in forum Excel General
    Replies: 3
    Last Post: 09-28-2010, 11:50 AM
  7. [SOLVED] Excel Opens In Full Screen
    By Yo in forum Excel General
    Replies: 1
    Last Post: 02-18-2005, 06:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1