Forcing the Ribbon to refresh

[John... Visio MVP]

I have an English and a French Group on the ribbon whose visibility is
controlled by a variable. It works fine on start up, but how do I force it
to refresh after the variable it depends on is set. Currently you have to
touch something on the ribbon before it will refresh.

John... Visio MVP

 

[Cindy M.]

Hi John...,

I have an English and a French Group on the ribbon whose visibility is
controlled by a variable. It works fine on start up, but how do I force it
to refresh after the variable it depends on is set. Currently you have to
touch something on the ribbon before it will refresh.

What kind of thing should force it to refresh?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[John... Visio MVP]

Hi John...,

What kind of thing should force it to refresh?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)


This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

In the Autonew of the template is a dialog that asks several questions
including language of choice. Since the template is initially in English
(the primary language), the group within the ribbon is also English, but if
the user changes languages, the group within the Ribbon is not refreshed.
When the document is opened at a later date, the Onload routine obtains the
language choice from a file and sets the visibility of the English and
French group accordingly.

John... Visio MVP

 

[Doug Glancy]

John,

I believe you are looking for the InvalidateControl method as described
here:

http://www.oaltd.co.uk/Spreads/Excel2007VBAProgRef_ch14.pdf

Look for the section on page 309 called "Changing Controls at runtime. It
specifically refers to multiple language applications. (InvalidateControl
is a misleading name, "RefreshControl" might be more accurate).

hth,

Doug

 

[John... Visio MVP]

I had tried that earlier in the week, but ended up with errors about a non
existent "With". It was an intense week, so I'll give it another try.

Thanks.
John... Visio MVP

 

[Doug Glancy]

John,

It took me a while to get it right. Good luck.

You probably know this, but if it was a compile error about along the lines
of "End With without With" it could also refer to an unmatched If, For, etc.

Doug