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
	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