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

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.

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.DisableAskAQuestionDropdow n = True 'True = hidden and False = visible

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


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

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

Change true to false to get it back.



Ian Elliott wrote:

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.

--

Dave Peterson