Access MVP (2010-2015)
Using just…
CommandBars.ExecuteMso "MinimizeRibbon"
..fails. Why? Because if the Ribbon is already minimized it will actually maximize. So, you need to check the Ribbon state first…
If Not CommandBars.GetPressedMso("MinimizeRibbon") Then
CommandBars.ExecuteMso "MinimizeRibbon"
End If
760 total views, 2 views today
