how get rid of "Type a question for help" box

[Guest]

Thanks for any help.
I have my standard Excel menu bar, with File Edit, etc, and then some
buttons I've chosen, like Auto Sum, Format Painter, etc. There is also the
"Type a question for help" text box there, is there a way of getting rid of
this to free up some space, so I can put more often used buttons there? I can
always look at it from the Help menu.
Thanks.

 

[Ron de Bruin]

Hi Ian

You can use

""Type a question for Help""
If you want to remove "Type a question for Help" on the Worksheet Menu Bar then you can use this line.
Application.CommandBars.DisableAskAQuestionDropdown = True 'True = hidden and False = visible

From this page
http://www.rondebruin.com/menuid.htm

 

[Dave Peterson]

Hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
Application.CommandBars.DisableAskAQuestionDropdown = True

Change true to false to get it back.