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
Bookmarks