Hide Formula bar while workbook is open

[OMER]

Hola,
I wonder if there is a way to prevent a user to activate the formula bar
while a specific worbook is open. I hide it inside the openning macro with
the following command:

Application.DisplayFormulaBar = False

But the user can go to the ribon menus and activate it back.
I want it top remain hidden until the workbook is closed.

Thank you for your help.
OMER

 

[Dennis Tucker]

One way to do this, but not too proper is

Sub Workbook_Open()

Again:
Application.DisplayFormulaBar = False
DoEvents ' maybe
use many of these
GoTo Again

End Sub

It should continuously try to remove the formula bar.

Dennis