How to modify ribbon with VBA with XLM script and without USysRibbons RRS feed

All replies

  • Hi technet65,

    According to your description, Once you've written a ribbon customization, you need a way to load it into Access. There are two ways to do this:

    Using the USysRibbons Table

    The easiest way is to use a user-defined system table called USysRibbons.

    For more information, click here to refer about Customize the Ribbon

    Using the LoadCustomUI Method

    Obviously any data you store in the database adds to its size. If you are using several ribbons in an application, you might want to store ribbons external to your database. Access 2007 includes a new method on the Application object called LoadCustomUI that allows you to do this.

    For more information, click here to refer about Chapter 11: Creating Dynamic Ribbon Customizations (1 of 2)

    Monday, June 13, 2016 5:50 AM
  • Hi David,

    Thanks a lot for your response. It's exactly what I looked for !

    Wednesday, June 22, 2016 9:57 AM
  • Hi technet65,

    If you find the reply is helpful, please mark it as an answer.

    Thanks for your understanding.
    Thursday, June 23, 2016 9:46 AM