I have the following code within ThisWorkbook which I wanted to use to
Display the formula bar when a particular file is closed. I don't want
the formula bar shown when this file is open, but do for my other
files and I have a Application.DisplayFormulaBar = False line in a
Workbook_Open sub. Problem being is on close it doesn't display the
formula bar, why is that?

Private Sub Workbook_close()
Application.DisplayFormulaBar = True

End Sub