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

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






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


"Peter Rooney" <PeterRooney@discussions.microsoft.com> wrote in message news:BB42A98C-F02E-46FC-BE2E-B4EAD97D566B@microsoft.com...
> 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

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" <rondebruin@kabelfoon.nl> wrote in message news:%23Ot$4sD7FHA.1484@tk2msftngp13.phx.gbl...
> 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.DisableAskAQuestionDropdown = True 'True = hidden and False = visible
>
>
>
>
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "Peter Rooney" <PeterRooney@discussions.microsoft.com> wrote in message news:BB42A98C-F02E-46FC-BE2E-B4EAD97D566B@microsoft.com...
>> 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
>
>

Peter,

I too determined whether has the help

try it,

Application.CommandBars.DisableAskAQuestionDropdown = 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

Chijanzen

Thank you very much! :-)

Have a good weekend!

Pete

"chijanzen" wrote:

> Sorry
>
> Application.CommandBars.DisableAskAQuestionDropdown = True
>
> --
> 天行健，君�*�以自強不息
> 地勢坤，君�*�以厚德載物
>
> http://www.vba.com.tw/plog/
>
>
> "chijanzen" wrote:
>
> > Peter,
> >
> > I too determined whether has the help
> >
> > try it,
> >
> > Application.CommandBars.DisableAskAQuestionDropdown = 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

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" <rondebruin@kabelfoon.nl> wrote in message news:%23Ot$4sD7FHA.1484@tk2msftngp13.phx.gbl...
> > 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.DisableAskAQuestionDropdown = True 'True = hidden and False = visible
> >
> >
> >
> >
> >
> >
> > --
> > Regards Ron de Bruin
> > http://www.rondebruin.nl
> >
> >
> > "Peter Rooney" <PeterRooney@discussions.microsoft.com> wrote in message news:BB42A98C-F02E-46FC-BE2E-B4EAD97D566B@microsoft.com...
> >> 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
> >
> >
>
>
>

Sorry

Application.CommandBars.DisableAskAQuestionDropdown = True

--
天行健，君�*�以自強不息
地勢坤，君�*�以厚德載物

http://www.vba.com.tw/plog/


"chijanzen" wrote:

> Peter,
>
> I too determined whether has the help
>
> try it,
>
> Application.CommandBars.DisableAskAQuestionDropdown = 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