You are here:   19

19

How to identify the Ribbon state? FAQ Link

With following code you can identify the Ribbon state:

Function RibbonState() As Long
'Result: 0=normal, -1=autohide
  
    RibbonState = (CommandBars("Ribbon").Controls(1).Height < 100)
End Function

Thanks to Sascha Trowitzsch: http://www.mosstools.de/

Or you can read the registry:

[HKEY_CURRENT_USER]\Software\Microsoft\Office\1x.0\Common\Toolbars\Access

Value Name:     QuickAccessToolbarStyle
Value Data:      0      (ribbon = normal)
Value Data:      4      (ribbon = autohide)

 

This Sample Database shows how to set the Ribbon state by VBA.  


In Access 2010 you can change the Ribbon state with:

   CommandBars.ExecuteMso "MinimizeRibbon"

Last Updates:

25.10.2018
Update Site "Trusted Locations" ...

22.10.2018
New Download added. ...

08.04.2018
IDBE RibbonCreator 2016 (x86 and x64) for Office 2013 and Office 2016 - new release. ...

04.08.2017
Add new Link. ...

 

Last update: