So I did some searching and found the thread below that "sort of" solves a problem I had, which was the title bar in Excel showing the filename & a dropdown menu that prompts you on where to save the file (amongst other actions):
www.mrexcel.com
Macro:
However, when I run that macro, it not only removes the filename from the title bar at the top of the Excel window, but also on the taskbar icon (which I don't want).
BEFORE running macro:
AFTER running macro:
Is there any way to remove the filename/dropdown only from the title bar at the top, while leaving it intact on the taskbar? And if so, I would prefer it to always be removed, vs having to run a macro every time I open a new Excel window.
Alternately, I wouldn't be completely opposed to having the title bar filename moved all the way to the left or all the way to the right, instead of smack dab in the MIDDLE of the title bar....soooo annoying.
Hide the file name at the very top of excel application
I'm trying to present a score card in a Zoom meeting by sharing a screen with Excel running. I'm using an Excel sheet with a ton of conditional formatting and formulas to calculate a complex final score, and when I'm sharing the screen I don't wan it to look like Excel. I've hidden almost...
Macro:
VBA Code:
Sub test()
Application.Caption = " "
ActiveWindow.Caption = ""
End SubHowever, when I run that macro, it not only removes the filename from the title bar at the top of the Excel window, but also on the taskbar icon (which I don't want).
BEFORE running macro:
AFTER running macro:
Is there any way to remove the filename/dropdown only from the title bar at the top, while leaving it intact on the taskbar? And if so, I would prefer it to always be removed, vs having to run a macro every time I open a new Excel window.
Alternately, I wouldn't be completely opposed to having the title bar filename moved all the way to the left or all the way to the right, instead of smack dab in the MIDDLE of the title bar....soooo annoying.
