Hide Formula bar while workbook is open
 

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

Hide Formula bar while workbook is open
 

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


"OMER" wrote in message
...
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