Code to Minimize the riboon
 

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

Code to Minimize the riboon
 

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" wrote in message ...
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

Code to Minimize the riboon
 

And SendKeys doesn't work in Vista ...

--
Cheers
macropod
[MVP - Microsoft Word]


"Ron de Bruin" wrote in message ...
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" wrote in message ...
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

Code to Minimize the riboon
 

Thanks.
You have confirmed what I thought.

"macropod" wrote:

And SendKeys doesn't work in Vista ...

--
Cheers
macropod
[MVP - Microsoft Word]


"Ron de Bruin" wrote in message ...
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" wrote in message ...
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