View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Disable formula Bar in Option Menu

Application.DisplayFormulaBar = false/true

Regards,
Peter T

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