View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default DISABLE FORMULA BAR

Hi André,

Not sure what you mean. Maybe:

Application.DisplayFormulaBar = False

?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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