15. Sample database RibbonState (Zip Archiv 93 KB).

 

This sample shows how to identify the Ribbon state, whether it is maximized or on auto-hide and how to set the state by VBA.

Many thanks to Sascha Trowitzsch:

 

In Access 2010 you can change the Ribbon state with:

   CommandBars.ExecuteMso "MinimizeRibbon"


Ensure that the data base is stored in a trusted location before you start it.




Back