Help: Global Ribbon Object methods and properties

Ribbon Object

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
#End If


0-based index of the ActiveTab. This property is writable. You can use it to select any visible Ribbon tab in your macro.


Returns Tabs collection.

Tabs( 1-based index )
Tabs( name )

Returns Tab object from collection by index or by name.


If this property is set to FALSE, Ribbon became insible and application looks like a dialog box.

Application with hidden ribbon:

Hidden Ribbon