Help: Display Tabs on the Ribbon Control

Show(Hide) Tabs

Show\Hide ribbon tabs

Use Visible property of the Tab Object to show or hide the Tab.

#If XLC Then
	Application.Ribbon.Tabs(TAB_PRINT).Visible = true
#End If
	

This code makes Print tab visible.

The code below completely hides Ribbon:

#If XLC Then
	Application.Ribbon.Visible = false
#End If
	

To make it visible again you should change Visible property to true.