Change the Position of a Tab on the Ribbon Excel

Change the Position of a Tab on the Ribbon Excel

Change the Position of a Tab on the Ribbon

You can change the order of custom tabs on a Ribbon by using the Tab Collection Editor. You can position custom tabs before or after a built-in tab on the Ribbon. A built-in tab is a tab that is already on the Ribbon of a Microsoft Office application. For example, the Data tab is a built-in tab in Excel.

To change the order of tabs on the Ribbon:

  1. Select the Ribbon code file (.vb or .cs file) in Solution Explorer
  2. On the View menu, click Designer
  3. Right-click the Ribbon Designer, and then click Properties
  4. In the Properties window, select the Tabs property, and then click the ellipsis button (ASP.NET Mobile Designer ellipse)
  5. The Tab Collection Editor appears
  6. In the Tab Collection Editor, in the Members list, select the tab you want to move and click the up or down arrows to change the tab order

To position a tab before or after a built-in tab on the Ribbon:

  1. In the Ribbon Designer, select a custom tab.
  2. In the Properties window, expand the ControlId property, and then make sure that the value of the ControlIdType property is set to Custom.
  3. In the Properties window, expand the Position property.
  4. Set the PositionType property to the appropriate value:
    • BeforeOfficeId positions the group before a specified built-in tab.
    • AfterOfficeId positions the group after a specified built-in tab.
  5. Set the OfficeId property to the control ID of a built-in tab.

Next>>Export a Ribbon from the Ribbon Designer to Ribbon XML

Leave a Reply

Your email address will not be published.