Results 1 to 4 of 4

Thread: Hide Excel Tabs-Heading-Formula Bar on Opening

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Nov 2015
    Posts
    43
    Location

    Hide Excel Tabs-Heading-Formula Bar on Opening

    I would like to have a full screen upon opening an excel file. Can you tell me where should I place the code
    so that the workbook is displayed full screen with no Formula bar, heading and tabs etc.



    Sub HideExcelItems()
    
    Application.DisplayFullScreen = True
    Application.DisplayFormulaBar = False
    ActiveWindow.DisplayWorkbookTabs = False
    ActiveWindow.DisplayHeadings = False
    ActiveWindow.DisplayGridlines = False
    
    End Sub
    Last edited by Zack Barresse; 04-27-2016 at 11:48 AM. Reason: Added CODE tags

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •