How to run a commandbar controled module inside a Macro
I have installed an Excel module to translate selected cells into another language. The module is controled by a set of command bars. I want to call the translation module from inside a Macro, but I don't know how. I tried the macro recording, but it did not record any code. Below is part of the translation commandbar module. Can anyone tell me how to call the module from a Macro? Thanks.
Sub LocalizeButtons()
Dim CommandBar As CommandBar
Dim ComboBox As CommandBarComboBox
Set CommandBar = CommandBars("PROMT6 SmarTool")
Set CommandBarControl = CommandBar.FindControl(Tag:="PROMT_ST_DIRECTION")
Set ComboBox = CommandBarControl
ComboBox.Clear
CommandBarControl.Caption = "Direction of Translation"
CommandBarControl.TooltipText = "Direction of Translation"
CommandBarControl.Enabled = True
Set CommandBarControl = Nothing
...
End Sub
I have installed an Excel module to translate selected cells into another language. The module is controled by a set of command bars. I want to call the translation module from inside a Macro, but I don't know how. I tried the macro recording, but it did not record any code. Below is part of the translation commandbar module. Can anyone tell me how to call the module from a Macro? Thanks.
Sub LocalizeButtons()
Dim CommandBar As CommandBar
Dim ComboBox As CommandBarComboBox
Set CommandBar = CommandBars("PROMT6 SmarTool")
Set CommandBarControl = CommandBar.FindControl(Tag:="PROMT_ST_DIRECTION")
Set ComboBox = CommandBarControl
ComboBox.Clear
CommandBarControl.Caption = "Direction of Translation"
CommandBarControl.TooltipText = "Direction of Translation"
CommandBarControl.Enabled = True
Set CommandBarControl = Nothing
...
End Sub