Excel 2000

Would like to disable FORMULA BAR from Worksheet Menu Bar (the forth element
of the list

I tried this ... did not worked

Application.CommandBars("DISPLAY").Controls.Item(3).Enabled = False

Thanks

André Lavoie
Quebec

Hi André,

Not sure what you mean. Maybe:

Application.DisplayFormulaBar = False

?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"lavoie" <(E-Mail Removed)> wrote in message news:e9Lqi.38371$(E-Mail Removed)...
| Excel 2000
|
| Would like to disable FORMULA BAR from Worksheet Menu Bar (the forth element
| of the list
|
| I tried this ... did not worked
|
| Application.CommandBars("DISPLAY").Controls.Item(3).Enabled = False
|
| Thanks
|
| André Lavoie
| Quebec
|
|
|

Hi Niek

I know that command but is not what I search

I would like the user could not find and activate FORMULA BAR Command from
the Menu Bar list


"Niek Otten" <(E-Mail Removed)> a écrit dans le message de news:
u$i$(E-Mail Removed)...
> Hi André,
>
> Not sure what you mean. Maybe:
>
> Application.DisplayFormulaBar = False
>
> ?
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "lavoie" <(E-Mail Removed)> wrote in message
news:e9Lqi.38371$(E-Mail Removed)...
> | Excel 2000
> |
> | Would like to disable FORMULA BAR from Worksheet Menu Bar (the forth
element
> | of the list
> |
> | I tried this ... did not worked
> |
> | Application.CommandBars("DISPLAY").Controls.Item(3).Enabled = False
> |
> | Thanks
> |
> | André Lavoie
> | Quebec
> |
> |
> |
>
>

You can disable this option

See
http://www.rondebruin.nl/menuid.htm

You can use this

Application.CommandBars("Worksheet Menu Bar").FindControl _
(ID:=849, Recursive:=True).Enabled = False


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"lavoie" <(E-Mail Removed)> wrote in message news:Z9Mqi.40375$(E-Mail Removed)...
> Hi Niek
>
> I know that command but is not what I search
>
> I would like the user could not find and activate FORMULA BAR Command from
> the Menu Bar list
>
>
> "Niek Otten" <(E-Mail Removed)> a écrit dans le message de news:
> u$i$(E-Mail Removed)...
>> Hi André,
>>
>> Not sure what you mean. Maybe:
>>
>> Application.DisplayFormulaBar = False
>>
>> ?
>>
>> --
>> Kind regards,
>>
>> Niek Otten
>> Microsoft MVP - Excel
>>
>> "lavoie" <(E-Mail Removed)> wrote in message
> news:e9Lqi.38371$(E-Mail Removed)...
>> | Excel 2000
>> |
>> | Would like to disable FORMULA BAR from Worksheet Menu Bar (the forth
> element
>> | of the list
>> |
>> | I tried this ... did not worked
>> |
>> | Application.CommandBars("DISPLAY").Controls.Item(3).Enabled = False
>> |
>> | Thanks
>> |
>> | André Lavoie
>> | Quebec
>> |
>> |
>> |
>>
>>
>
>