Hi,
how can disable the option "Formula Bar" in the Tools - Options -...?
I already used this:
Application.CommandBars("Worksheet Menu Bar").FindControl(ID:=849,
Recursive:=True).Enabled = False
but it's not enough...

Thanks in advance

Bye
BlackSun

Application.DisplayFormulaBar = false/true

Regards,
Peter T

<(E-Mail Removed)> wrote in message
news:e5147824-229d-42e9-bd9f-(E-Mail Removed)...
> Hi,
> how can disable the option "Formula Bar" in the Tools - Options -...?
> I already used this:
> Application.CommandBars("Worksheet Menu Bar").FindControl(ID:=849,
> Recursive:=True).Enabled = False
> but it's not enough...
>
> Thanks in advance
>
> Bye
> BlackSun

On 11 Mag, 11:54, "Peter T" <peter_t@discussions> wrote:
> Application.DisplayFormulaBar = false/true
>
> Regards,
> Peter T
>
> <black_...@email.it> wrote in message
>
> news:e5147824-229d-42e9-bd9f-(E-Mail Removed)...
>
> > Hi,
> > how can disable the option "Formula Bar" in the Tools - Options -...?
> > I already used this:
> > Application.CommandBars("Worksheet Menu Bar").FindControl(ID:=849,
> > Recursive:=True).Enabled = False
> > but it's not enough...
>
> > Thanks in advance
>
> > Bye
> > BlackSun

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

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

<(E-Mail Removed)> 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