That is a global setting and will affect all workbooks.

You could use Workbook event code to disable and enable.

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

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.DisplayFormulaBar = True
End Sub

If the workbook is to remain open whilst other workbooks are open use the
following.

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

Private Sub Workbook_Deactivate()
Application.DisplayFormulaBar = True
End Sub

Right-click on the Excel logo left of "File" on the menu and select "View Code"

Copy/paste into that module.

Gord Dibben  MS Excel MVP