Hiding the formula bar in Excel for a specific file

Question

Only in this particular Excel file would I wish the formula bar to be hidden. I am aware that VBA may be used to accomplish this (Application.DisplayFormulaBar = False), but I'm curious if there is another way, such as altering the CustomUI file.

Typically, I alter the CustomUI file to remove the ribbon, add unique tabs, etc. If we could use this method to conceal the formula bar, it would be good.

Answer 1

No, you cannot.

Unfortunately, altering the CustomUI file won't let you hide it. VBA must be used to hide the formula bar. You may just do the hide operation on the Workbook open event after all.

Private Sub Workbook_Open() 
    Application.DisplayFormulaBar = False 
End Sub 

You can turn it on/off depending on the active sheet like so:

Private Sub Workbook_SheetActivate(ByVal Sh As Object)

If Sh.Name = "Sheet1" Then
    Application.DisplayFormulaBar = False
Else
    Application.DisplayFormulaBar = True
End If

End Sub