[AccessD] A2012 Ribbon collapse (not hide) from code

Stuart McLachlan stuart at lexacorp.com.pg
Fri Feb 8 06:06:00 CST 2013


Just discovered, Access 2010:

CommandBars.ExecuteMso "MinimizeRibbon"

-- 
Stuart

On 8 Feb 2013 at 22:00, Stuart McLachlan wrote:

> 2007/10   I'm guessing it will work in 2012:
> 
> A real kludge, but I've never found an alternative. 
> 
> If CommandBars("ribbon").Height > 100 Then
> SendKeys "^{F1}", True
> End If 
> 
> -- 
> Stuart
> 
> On 8 Feb 2013 at 11:51, Gustav Brock wrote:
> 
> > Hi all
> > 
> > Is this possible? It's easy to _hide_ , but how to collapse (or minimize)?
> > Also, client is not interested in custom ribbons; the default is fine. 
> > 
> > /gustav
> > 
> > -- 
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> > 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list