Not sure I follow what you mean by "I can flag the Formula Bar option and it
show again". Are you saying you want to disable the option in Options/View.
AFAIK that's not possible unless you disable the Options dialog entirely.
One workaround would be to sub-class the Options button and intercept its
click event, call an ontime macro to set the option to your requirements
when the Options dialog is dismissed.

Regards,
Peter T

wrote in message

Application.DisplayFormulaBar = false/true


Hi,
yes I did it but if I choose Tools - Options - I can flag the "Formula
Bar" option and it show again.
I would like to disable that option

Thanks.

BlackSun