Change ribbon labels by VBA?

[Charlotte E.]

Hi,


I have a workbook with a built-in custion ribbon, which open together
with the workbook.

One of the buttons on this ribbon is a 'Toggle language' button, which
toggle the language of the entire workbook between English or Danish.

And this all works fine except for the ribbon itself - the labels in the
ribbon is per default in Danish language, but it would be nice, if the
ribbon also could toggle language.

So, question is: Can I change the labels in my custon ribbon via VBA?


Thanks

CE

 

[Charlotte E.]

I've now managed to make the ribbon appear in the correct language, when
the workbook is opened (what was the language when it was last saved).

So far, so good

But it could be nice if it could be done, while the workbook is opened
also...

Is there a way to 'refresh' a certain tab on a ribbon?


CE



Den 01.09.2012 09:23, Charlotte E. skrev:

 

[Charlotte E.]

Found it myself - .Invalidate did the trick

CE



Den 01.09.2012 09:23, Charlotte E. skrev:

 

[vjdeere]

Hi Charlotte,

Would you be able to share the solution, I am looking to do something similar but I am not able to find it on the web.

Kind Regards.