ukdane
12-03-2008, 04:39 AM
So,
I've created my program, and people are now testing it.
BUT I've already run into a problem.
Most of my users are running an "English" version of Excel 2003.
However one or two are begining to switch to a different language version.
In this case, a Danish version of Excel 2003.
This is causing a problem.
The problem is that the Menu and Toolbar functions only look for English text, and I need them to also operate for Danish Menus and Toolbars.
Is there a way that Excel can search for the language settings, and set up the menu and toolbars according to language?
iHelpMenu = cbMainMenuBar.Controls("Help").Index
cbMainMenuBar.Controls.Add(Type:=msoControlButton, Before:=iHelpMenu).Caption = "About"
cbMainMenuBar.Controls("About").Style = msoButtonCaption
cbMainMenuBar.Controls("About").OnAction = "showabout"
This code places an ABOUT button to the left og the HELP index. In the Danish version "HELP" is replaced with "HJ?LP"
Application.CommandBars("Formatting").Visible = False
Application.CommandBars("Standard").Visible = False
Application.CommandBars("Reviewing").Visible = False
Hides the relevant toolbars- I want to hide ALL the toolbars, except for my own custom toolbar.
Again in Danish, the toolbars are called something else.
If I just add the Danish equivalent, then I get an error in the English version, and the English toolbars cause an error in the Danish version.
How to I solve this conflict?
Thanks for helping!
I've created my program, and people are now testing it.
BUT I've already run into a problem.
Most of my users are running an "English" version of Excel 2003.
However one or two are begining to switch to a different language version.
In this case, a Danish version of Excel 2003.
This is causing a problem.
The problem is that the Menu and Toolbar functions only look for English text, and I need them to also operate for Danish Menus and Toolbars.
Is there a way that Excel can search for the language settings, and set up the menu and toolbars according to language?
iHelpMenu = cbMainMenuBar.Controls("Help").Index
cbMainMenuBar.Controls.Add(Type:=msoControlButton, Before:=iHelpMenu).Caption = "About"
cbMainMenuBar.Controls("About").Style = msoButtonCaption
cbMainMenuBar.Controls("About").OnAction = "showabout"
This code places an ABOUT button to the left og the HELP index. In the Danish version "HELP" is replaced with "HJ?LP"
Application.CommandBars("Formatting").Visible = False
Application.CommandBars("Standard").Visible = False
Application.CommandBars("Reviewing").Visible = False
Hides the relevant toolbars- I want to hide ALL the toolbars, except for my own custom toolbar.
Again in Danish, the toolbars are called something else.
If I just add the Danish equivalent, then I get an error in the English version, and the English toolbars cause an error in the Danish version.
How to I solve this conflict?
Thanks for helping!