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…
- User
in excel 2010, I want to open a workbook without menus and without scroll bars. How do I write this VBA code
- 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