You are here:   Home > Access - Ribbons > Update Ribbons Dynamically

Update Ribbons Dynamically

If you have setup a multi-lingual application you may want to change the Ribbon Labels dynamically. To do so the ribbon needs to be cached when loading. This can be done using callback onLoad of the <customUI> element.

Needed Ribbon XML:

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"
  onLoad="CallbackOnLoad">
</customUI>

To be copied to a standard module:

Option Compare Database
Option Explicit
  
Public gobjRibbon As IRibbonUI
  
Sub CallbackOnLoad(ribbon As IRibbonUI)
    ' Cache a copy of RibbonUI.
    Set gobjRibbon = ribbon
End Sub

Now you have the possibility to adjust single ribbon controls using gobjRibbon.InvalidateControl "ControlID"
or the entire ribbon using gobjRibbon.Invalidate.

 

 

 

Last Updates:

08.04.2018
IDBE RibbonCreator 2016 (x86 and x64) for Office 2013 and Office 2016 - new release. ...


04.08.2017
Add new Link. ...

04.01.2016
Add new Link. ...

22.09.2015
New - IDBE RibbonCreator 2016 32 Bit and 64 Bit (Version 1.1001) ...

 

Last update:
May 08, 2018, 19:11