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

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.

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: