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
> >
> >
>
>
>