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 everything in the UI, but I can't find a way to hide the very top bar of excel where it displays the file name.
Any suggestions on the code I could use to make that part of the UI disappear?
I'm OK with keeping the minimize, full screen and close buttons that seem to be in the same top bar. If they need to go in order to make the filename not be visible, that's fine.
And yes, I want to keep the scroll bar visible on the bottom of the screen if possible.
Here is what I have so far... this code runs when I press a button, and the reverse runs when I press another button so I can get the UI back if I need to.
Thanks for your help!
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 everything in the UI, but I can't find a way to hide the very top bar of excel where it displays the file name.
Any suggestions on the code I could use to make that part of the UI disappear?
I'm OK with keeping the minimize, full screen and close buttons that seem to be in the same top bar. If they need to go in order to make the filename not be visible, that's fine.
And yes, I want to keep the scroll bar visible on the bottom of the screen if possible.
Here is what I have so far... this code runs when I press a button, and the reverse runs when I press another button so I can get the UI back if I need to.
Thanks for your help!
VBA Code:
Sub TurnOffInterface()
'
' TurnOffInterface Macro
'
'
Application.ScreenUpdating = False
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
Application.DisplayFormulaBar = False
With ActiveWindow
.DisplayHeadings = False
End With
Application.DisplayStatusBar = Not Application.DisplayStatusBar
ActiveWindow.DisplayWorkbookTabs = False
Application.ScreenUpdating = True
End Sub