Change ribbon labels by VBA?
 

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

Change ribbon labels by VBA?
 

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:
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

Change ribbon labels by VBA?
 

Found it myself - .Invalidate did the trick :-)

CE



Den 01.09.2012 09:23, Charlotte E. skrev:
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

Change ribbon labels by VBA?
 

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.

On Sunday, 2 September 2012 05:47:56 UTC+1, Charlotte E. wrote:
Found it myself - .Invalidate did the trick :-)



CE







Den 01.09.2012 09:23, Charlotte E. skrev:

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