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