Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possibly a loaded question, but I think | Excel Discussion (Misc queries) | |||
multiple results display after filter function | Excel Worksheet Functions | |||
LookUp Type Question | Excel Worksheet Functions | |||
Sum if type question? | Excel Worksheet Functions | |||
Lookup Type Question | Excel Worksheet Functions |