I have a workbook and i'm hiding al commandbars at startup. When i close the workbook all the commandbars are set to the normal value. This works except for my formulabar.
this is my code:
Dim Bar As Object
For Each Bar In Application.CommandBars
Bar.Enabled = True
Next Bar
Application.DisplayFormulaBar = True
The strange thing is that i have a macro to restore the commandbars and leave my workbook open. When i run this macro, my formulabar gets visible. The code in this macro is exactly the same as in my 'close'-macro and is as shown above.
Perhaps somebody knows what causes this strange problem.
Many thanks!
John
this is my code:
Dim Bar As Object
For Each Bar In Application.CommandBars
Bar.Enabled = True
Next Bar
Application.DisplayFormulaBar = True
The strange thing is that i have a macro to restore the commandbars and leave my workbook open. When i run this macro, my formulabar gets visible. The code in this macro is exactly the same as in my 'close'-macro and is as shown above.
Perhaps somebody knows what causes this strange problem.
Many thanks!
John
