Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Ribbon in Excel 2007 | Excel Programming | |||
Change The Color of A Ribbon Tab | Excel Programming | |||
Ribbon displays labels even when showLabel is set to False | Excel Programming | |||
Change image for Ribbon items | Excel Programming | |||
Change Ribbon Tabs by hovering | Excel Discussion (Misc queries) |