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

Hi
Should that be Workbook_BeforeClose(Cancel as Boolean)?

Is workbook_close allowed (or still allowed?)
regards
Paul

On Mar 23, 8:50 am, "Sean" wrote:
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

On Mar 23, 9:00 am, wrote:
Hi
Should that be Workbook_BeforeClose(Cancel as Boolean)?

Is workbook_close allowed (or still allowed?)
regards
Paul

On Mar 23, 8:50 am, "Sean" wrote:



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- Hide quoted text -

- Show quoted text -

I'm not sure Paul, but your suggestion works wonderfully

Thanks