refreshRibbon?

**bagullo** · 04-02-2014, 08:59 AM

Hi,

I am investigating how to customize ribbon in xl2007-xl2010 and I see controls can be defined with some procedures suchas getItemLabel, getItemCount etc for dropdown menus

what I am curious is if it is possible to force "refresh" on the ribbon. If this dropdown is based on cells content, can I force the contents of the dropdown to refresh to reflect changes on the sheet?
this is certainly possible in xl2003 by deleting and recreating the toolbar

what I do not know is how to achieve the same with xl2007

any ideas?

**Izandol** · 04-02-2014, 09:20 AM

You must store reference to Ribbon in onLoad event and you may then use this IRibbonUI object to invalidate whole ribbon or individual controls.

**bagullo** · 04-02-2014, 10:05 AM

Thank you Izandol,

but i do not really understand
where do I need to put the code?
do you have example code "refresh" ribbon such as when workbook loads?

**Izandol** · 04-02-2014, 10:19 AM

Workbook ribbon will always refresh when it is loaded. You must put onLoad callback into CustomUI part - so it will start:

PHP Code:


<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<customUI onLoad="RibbonOnLoad

In workbook you will have:

Dim rib As IRibbonUI

Sub RibbonOnload(ribbon As IRibbonUI)
   Set rib = ribbon
End Sub

then you may call rib.Invalidate from other routines.

**bagullo** · 04-02-2014, 10:58 AM

Ok, now I understand a little more, but not yet all.
for instance, if I want the content of a drop down menu to refresh when I change sheets -- how should I do it?
I guess that the rib variable will not stay there for ever, will it?