|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 07:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com