I copied VBA code from Teach Excel (displayed below) that works perfectly. The macros hides all the Excel ribbons, tabs, vertical and horizontal scrol bars, column and row headings so you are left with only your date on the screen.
My issue is that when I save the Workbook with everything hidden, close out of the Workbook and reopen it later, all the Excel ribbons, tabs, vertical and horizontal scrol bars, column and row headings are back so I have to run the Macro again to hide everything again.
I am looking for a way to hide everything, save the Workbook with everything hidden and then be able to reopen that document with everything still hidden as opposed to running thre Macro again.
Thank you for your time, Mark
Sub HideAll()
' Excel VBA Tutorial - https://www.TeachExcel.com
' Hide the Horizontal Scroll Bar
ActiveWindow.DisplayHorizontalScrollBar = False
' Hide the Vertical Scroll Bar
ActiveWindow.DisplayVerticalScrollBar = False
' Hide the Row/Column Headings
ActiveWindow.DisplayHeadings = False
' Hide the Worksheet Tabs
ActiveWindow.DisplayWorkbookTabs = False
' Hide the Status Bar (bottom of the window)
Application.DisplayStatusBar = False
' Hide the Formula Bar
Application.DisplayFormulaBar = False
' Hide the Ribbon Menu and Quick Access Toolbar
Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"",False)"
' Display Full Screen
'Application.DisplayFullScreen = True
End Sub