Skip to content
The Chat Archive
gpt-3.5-turbo-0301· OpenAI WildChat-4.8M (AI2)

in excel 2010, I want to open a workbook without menus and without scroll bars. How do I…

  1. User

    in excel 2010, I want to open a workbook without menus and without scroll bars. How do I write this VBA code

  2. Assistant

    Sub OpenWorkbook() Application.DisplayFullScreen = True 'Display workbook in full screen mode Application.DisplayFormulaBar = False 'Hide formula bar Application.DisplayStatusBar = False 'Hide status bar ActiveWindow.DisplayWorkbookTabs = False 'Hide workbook tabs ActiveWindow.DisplayHeadings = False 'Hide row and column headings ActiveWindow.DisplayHorizontalScrollBar = False 'Hide horizontal scroll bar ActiveWindow.DisplayVerticalScrollBar = False 'Hide vertical scroll bar

    Workbooks.Open("Path to your workbook")

    End Sub