How to: Apply a Custom Ribbon When Starting Access

The ribbon uses text-based, declarative XML markup that simplifies creating and customizing the ribbon. With a few lines of XML, you can create just the right interface for the user. Access provides tremendous flexibility in customizing the ribbon UI. For example, customization markup can be stored in a table, embedded in a VBA procedure, stored in another Access database, or linked to from an Excel worksheet. This topic describes how to apply customized ribbons when opening a database.

Making the Ribbon Customization XML Available

Storing Ribbon Extensibility XML in a Table

One method that you can use to make ribbon customizations available is to store them in a table. If you store the customizations in a table named USysRibbons, the customizations can be implemented without using macros or VBA code.

USysRibbons is a user-created system table. The table must be created using specific column names in order for the ribbon customizations to be implemented. The following table lists the settings to use when creating the USysRibbons table.

Column Name	Data Type	Description
RibbonName	Text	Contains the name of the custom ribbon to be associated with this customization.
RibbonXML	Memo	Contains the Ribbon Extensibility XML (RibbonX) that defines the ribbon customization.

Loading Ribbon Extensibility XML Programmatically

You can use the LoadCustomUI method to load ribbon customizations programmatically. Typically, to create and make the ribbon available to the application, you first create a module in the database with a procedure that calls the LoadCustomUI method, passing in the name of the ribbon and the XML customization markup.

The XML markup can come from a Recordset object created from a table, from a source external to the database such as an XML file that you parse into a string, or from XML markup embedded directly inside the procedure. You can make different ribbons using multiple calls to the LoadCustomUI method, passing in different XML markup as long as the name of each ribbon and the id attribute of the tabs that make up the ribbon are unique.

After the procedure is complete, you then create an AutoExec macro that calls the procedure by using the RunCode action. That way, when the application is started, the LoadCustomUI method is automatically executed and all of the custom ribbons are made available to the application.

Applying Customized Ribbons When Access Starts

To apply a custom UI so that it is available when the application starts, use the following procedure:

1. Follow the process described previously to make the customized ribbons available to the application.

2. Close and then restart the application.

3. Click the Microsoft Office Button and then click Access Options.

4. Click the Current Database option and then, in the Ribbon and Toolbar Options section, click the Ribbon Name list and select a ribbon.

5. Now close and restart the application. The UI you selected is displayed.

Note

For more information about the ribbon UI in other Office applications, see Overview of the Office Fluent Ribbon.