I put a command in the Workbook_Open event to make
DisplayFormulaBar = false, no problems.
But, in the Workbook_BeforeClose event, DisplayFormulaBar
= True, does not work. I have no errors, but the
DisplayFormulaBar continue False.
Why does not work ?

Regargs,
GL...

Excel needs to be sure what you mean to apply it to; this property applies
to the Application object, so this code works:

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

When you remove the object qualifier, it doesn't work.
--
HTH -

-Frank
Microsoft Excel MVP
Dolphin Technology Corp.
http://vbapro.com



"Silverio" wrote in message
...
I put a command in the Workbook_Open event to make
DisplayFormulaBar = false, no problems.
But, in the Workbook_BeforeClose event, DisplayFormulaBar
= True, does not work. I have no errors, but the
DisplayFormulaBar continue False.
Why does not work ?

Regargs,
GL...