ChrisBester
New Member
- Joined
- Aug 14, 2017
- Messages
- 4
Dear All
I recently upgraded to Excel 2013 and have this problem that when I run the Application.DisplayFormulaBar = False statement, it does not hide the Formula Bar. The code worked perfectly in 2010 and 2007 versions. It seems like a bug in Excel 2013.
Please help.. See code below
Thanks in advance
I recently upgraded to Excel 2013 and have this problem that when I run the Application.DisplayFormulaBar = False statement, it does not hide the Formula Bar. The code worked perfectly in 2010 and 2007 versions. It seems like a bug in Excel 2013.
Please help.. See code below
Code:
Sub Auto_Open()
Dim wbBook As Workbook
Dim wsSheet As Worksheet
Application.ScreenUpdating = False ' <-- prevent screen screen flicker as sheets are updated
Set wbBook = ThisWorkbook
Application.WindowState = xlMaximized
Application.DisplayFullScreen = True ' <-- to force full screen display
Application.DisplayFormulaBar = False ' <-- to hide the formula bar
Application.OnKey "{ESC}", "" ' <-- to disable "ESC" Key
For Each wsSheet In wbBook.Worksheets
If Not wsSheet.Name = "Blank" Then
wsSheet.Activate
With ActiveWindow
.DisplayHeadings = False ' <-- to disable row & column headings
.DisplayWorkbookTabs = False ' <-- to disable worksheet tabs
.DisplayHorizontalScrollBar = False
.DisplayFormulas = False
End With
End If
Next wsSheet
Sheets("HomePage").Select ' <-- To select homepage by default on opening
Application.ScreenUpdating = True
End Sub
Last edited by a moderator: