| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I delete "Type A Question for Help"
Good morning all (collective groan from Tom, Ron & Chijanzen)
Can anyone tell me how to reference the "Type a question for help" tool that appears on the MenuBar. I know how to delete it, once I can reference it, it's the first bit that's puzzling me. Thanks in advance Pete |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I delete "Type A Question for Help"
Hi Peter
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 -- Regards Ron de Bruin http://www.rondebruin.nl "Peter Rooney" wrote in message ... Good morning all (collective groan from Tom, Ron & Chijanzen) Can anyone tell me how to reference the "Type a question for help" tool that appears on the MenuBar. I know how to delete it, once I can reference it, it's the first bit that's puzzling me. Thanks in advance Pete |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I delete "Type A Question for Help"
Don't forget to test the Excel version before you run the code
If Val(Application.Version) 9 Then -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Hi Peter 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 -- Regards Ron de Bruin http://www.rondebruin.nl "Peter Rooney" wrote in message ... Good morning all (collective groan from Tom, Ron & Chijanzen) Can anyone tell me how to reference the "Type a question for help" tool that appears on the MenuBar. I know how to delete it, once I can reference it, it's the first bit that's puzzling me. Thanks in advance Pete |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I delete "Type A Question for Help"
Peter,
I too determined whether has the help try it, Application.CommandBars.DisableAskAQuestionDropdow n = False -- 天行健，君*以自強不息 地勢坤，君*以厚德載物 http://www.vba.com.tw/plog/ "Peter Rooney" wrote: Good morning all (collective groan from Tom, Ron & Chijanzen) Can anyone tell me how to reference the "Type a question for help" tool that appears on the MenuBar. I know how to delete it, once I can reference it, it's the first bit that's puzzling me. Thanks in advance Pete |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I delete "Type A Question for Help"
Chijanzen
Thank you very much! :-) Have a good weekend! Pete "chijanzen" wrote: Sorry Application.CommandBars.DisableAskAQuestionDropdow n = True -- 天行健，君*以自強不息 地勢坤，君*以厚德載物 http://www.vba.com.tw/plog/ "chijanzen" wrote: Peter, I too determined whether has the help try it, Application.CommandBars.DisableAskAQuestionDropdow n = False -- 天行健，君*以自強不息 地勢坤，君*以厚德載物 http://www.vba.com.tw/plog/ "Peter Rooney" wrote: Good morning all (collective groan from Tom, Ron & Chijanzen) Can anyone tell me how to reference the "Type a question for help" tool that appears on the MenuBar. I know how to delete it, once I can reference it, it's the first bit that's puzzling me. Thanks in advance Pete |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I delete "Type A Question for Help"
Ron,
Thank you very much. Have a good weekend :-) Pete "Ron de Bruin" wrote: Don't forget to test the Excel version before you run the code If Val(Application.Version) 9 Then -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Hi Peter 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 -- Regards Ron de Bruin http://www.rondebruin.nl "Peter Rooney" wrote in message ... Good morning all (collective groan from Tom, Ron & Chijanzen) Can anyone tell me how to reference the "Type a question for help" tool that appears on the MenuBar. I know how to delete it, once I can reference it, it's the first bit that's puzzling me. Thanks in advance Pete |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I delete "Type A Question for Help"
Sorry
Application.CommandBars.DisableAskAQuestionDropdow n = True -- 天行健，君*以自強不息 地勢坤，君*以厚德載物 http://www.vba.com.tw/plog/ "chijanzen" wrote: Peter, I too determined whether has the help try it, Application.CommandBars.DisableAskAQuestionDropdow n = False -- 天行健，君*以自強不息 地勢坤，君*以厚德載物 http://www.vba.com.tw/plog/ "Peter Rooney" wrote: Good morning all (collective groan from Tom, Ron & Chijanzen) Can anyone tell me how to reference the "Type a question for help" tool that appears on the MenuBar. I know how to delete it, once I can reference it, it's the first bit that's puzzling me. Thanks in advance Pete |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Type mismatch" when I try to fill an Array variable with "+" | Excel Discussion (Misc queries) | |||
| how do I type "itis" without Excel putting a space "it is"? | Excel Worksheet Functions | |||
| Where is the toolbar with the "bold type", "font type", options | New Users to Excel | |||
| "FIND" generates "Type mismatch" error | Excel Programming | |||
Linear Mode
