Hide Control buttons, and make worksheet fullscreen.

Hello abrunstad,

I would advise against removing the Excel title bar as it contains the main menu and doing so would deprive your users of much needed functionality. Other than that caveat, yes it can be done.

That's called a dictator application. I would respectfully suggest that if you and VBA don't already do synchronized swimming, don't jump in to that end of the pool.

Originally Posted by abrunstad

Thanks guys!

Hello abrunstad!
I really need the same functionality in Excel 2010. Could you please tell if you achived that and how?
I use the following code

 Application.DisplayFullScreen = True
    Application.CommandBars("Full Screen").Enabled = False
    ActiveWindow.DisplayWorkbookTabs = False
    Application.DisplayStatusBar = False
    Application.DisplayDocumentActionTaskPane = False    
    Application.CommandBars.ActiveMenuBar.Enabled = False 
    With ActiveWindow
        .DisplayHorizontalScrollBar = False
        .DisplayVerticalScrollBar = False
        .DisplayHeadings = False
    End With

Excel goes fullscreen, controls, scrollbars are hide, but Title stays there forever (see attachment). I would really like true fullscreen without anything but my worksheet as in Excel 2003.

Thank you very much!

Please start your own thread.