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

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