Ribbon Class Members

Ribbon Object is a representation of the Application Ribbon in the Visual Basic Code. It can be accessed as a Ribbon property of the Application object
#If XLC Then
Application.Ribbon
#End If
ActiveTab
0-based index of the ActiveTab. This property is writable. You can use it to select any visible Ribbon tab in your macro.
Tabs
Returns Tabs collection.
Tabs( 1-based index )
Tabs( name )
Returns Tab object from collection by index or by name.
Visible
If this property is set to FALSE, Ribbon became insible and application looks like a dialog box.
Application with hidden ribbon:
Hidden Ribbon