Hello All

Is there any vba code available to "Minimize the Ribbon" and leave the tabs
showing, exactly as a user would do using the context menu from the QAT or
Ribbon.

I know "Application.SendKeys ("^{F1}")" is a work around but wondered if
there was something more built in.

Thanks

Hi Cresta

As far as I know send keys is the only way if you want to leave the tabs

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Cresta" <(E-Mail Removed)> wrote in message news:EB4FEBBC-01E6-4459-A65B-(E-Mail Removed)...
> Hello All
>
> Is there any vba code available to "Minimize the Ribbon" and leave the tabs
> showing, exactly as a user would do using the context menu from the QAT or
> Ribbon.
>
> I know "Application.SendKeys ("^{F1}")" is a work around but wondered if
> there was something more built in.
>
> Thanks

And SendKeys doesn't work in Vista ...

--
Cheers
macropod
[MVP - Microsoft Word]


"Ron de Bruin" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)...
> Hi Cresta
>
> As far as I know send keys is the only way if you want to leave the tabs
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "Cresta" <(E-Mail Removed)> wrote in message news:EB4FEBBC-01E6-4459-A65B-(E-Mail Removed)...
>> Hello All
>>
>> Is there any vba code available to "Minimize the Ribbon" and leave the tabs
>> showing, exactly as a user would do using the context menu from the QAT or
>> Ribbon.
>>
>> I know "Application.SendKeys ("^{F1}")" is a work around but wondered if
>> there was something more built in.
>>
>> Thanks

Thanks.
You have confirmed what I thought.

"macropod" wrote:

> And SendKeys doesn't work in Vista ...
>
> --
> Cheers
> macropod
> [MVP - Microsoft Word]
>
>
> "Ron de Bruin" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)...
> > Hi Cresta
> >
> > As far as I know send keys is the only way if you want to leave the tabs
> >
> > --
> >
> > Regards Ron de Bruin
> > http://www.rondebruin.nl/tips.htm
> >
> >
> > "Cresta" <(E-Mail Removed)> wrote in message news:EB4FEBBC-01E6-4459-A65B-(E-Mail Removed)...
> >> Hello All
> >>
> >> Is there any vba code available to "Minimize the Ribbon" and leave the tabs
> >> showing, exactly as a user would do using the context menu from the QAT or
> >> Ribbon.
> >>
> >> I know "Application.SendKeys ("^{F1}")" is a work around but wondered if
> >> there was something more built in.
> >>
> >> Thanks
>